A formula that calculates the total from the adjacent cell through the first non-numeric cell using the SUM function