subtotal

[Todd]

Hi,

I want to have column totals at the top of a column and
having trouble because I have group totals in the same
column. How can I ignore the group totals in the column
total? I tried the subtotal function but the column total
includes any number below it.

TIA


Todd

Column Total
=Sum(g5:g100)

Dir A
Dir B
Dir C

Dir Group
Subtotal(g5:g8)

Sir A
Sir B
Sir C

Sir Group
Subtotal(g12:g14)

 

[Debra Dalgleish]

Use the Subtotal function to calculate the group totals, and use the
subtotal function to calculate the grand total. The subtotal function
will ignore other subtotals within its range.

Or use Data>Subtotal, and remove the check mark from 'Summary below data'