Sub Total and Group Total on numerical column with errors

In a calculation column if you get errors like #N/A, #Div, or etc then this would distort your sub and group totals. To correctly sum for sub and group totals just put your column cells formula into “IFError” formula.

The structure of formula would be =Iferror(calculation formula , 0). This mean if any error come up then “if error” convert the error into zero, and you won’t get an error in group totals.

Contact Us

Learn Excel Tricks