Sub totals and Totals

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Thanks bpeltzer, your vexample did work. In think the function needs to be
written more clearly in Excel help files.
 
Back
Top