Forum Discussion

Copper Contributor

Aug 05, 2020

Solved

Subtotals and Grand totals

I have numbers that range from B3 to B53 and a subtotal =subtotal(9,b3:b53) in B54. I have another set of numbers from B58 to B180 and a subtotal =subtotal(9,b58:b180) in B181. In B 186 I have the ...

excel

SergeiBaklan
Aug 05, 2020
Rawle Mars

Please try in B186

=SUBTOTAL(109,B2:B181)

Poogermum

Brass Contributor

Aug 05, 2020

Rawle MarsHave you considered adding a Pivot table or a summary table on a separate sheet to make it easier to look at the data instead of having subtotals and grand totals on the same sheet?