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.

"RM" wrote:

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

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

"RM" wrote:

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

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


"RM" wrote:

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