Sub totals and Totals

[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

 

[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.

 

[bj]

the subtotal() command will let you do this.
check the description in help

 

[RM]

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