A function that calculates the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.