Sub totals and Totals

R

RM

Can I insert the formula for sub totals and then get the grand total in a
worksheet without creating a table or database. I know it can be done in
Lotus 123
 
B

bpeltzer

Sure. The subtotal function will ignore intermediate subtotals.
Ex: in A10, =subtotal(9,a1:a9). in A20, =subtotal(9,a11:a19). In A21, the
grand total would be =subtotal(9,a1:a20). If you use Data > Subtotals and
apply two levels of subtotals, you'll see these are the functions that Excel
creates for you.
 
R

RM

Thanks bpeltzer, your vexample did work. In think the function needs to be
written more clearly in Excel help files.
 
Top