Example Data FormulaDescriptionResult =SUBTOTAL(9,A2:A5)The sum of the subtotal of the cells A2:A5, using 9 as the first argument.303 =SUBTOTAL(1,A2:A5)The average of the subtotal of the cells A2:A5, using 1 as the first argument.75.75 Notes 5 more rows