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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Old Lotus Sub Total & Grand Total formula 2
Referencing a pivot tables Grand Totals Column 1
I can't see Grand total rows even though the option's switched on 2
calculate grand total 2
Grand Totals with Nested Sub Totals 7
SUBTOTAL function 3
Grand Totals 3
Pivot table grand total location 1

Back
Top