Subtotal Function

  • Thread starter Thread starter Cynthia
  • Start date Start date
C

Cynthia

Using the Data>subtotal, my subtotal of a one item group
is not the subtotal of the one item. It comes up with an
altogether different subtotal. Any idea how that can
happen?
 
Hi
maybe some numbers are actually stores as 'Text'. You may post some
sample rows of your data (plain text - no attachment please), your
expected result and the result you got
 
Hi back
turns out to be user error. The information was copied
from another sheet that had included additional
information and when it was pasted to another sheet, it
brought over and added in the total. Thank you for your
attention.
 
Hi Cynthia,
You should not be able to take a subtotal of a subtotal

0 D1: 0
1 D2: 1
2 D3: 2
4 D4: 4
8 D5: 8
15 D6: =SUBTOTAL(9,D$2:D5)
15 D7: =SUBTOTAL(9,D$2:D6)
16 D8: 16
31 D9: =SUBTOTAL(9,D$2:D8)
31 D10: =SUBTOTAL(9,D$2:D9)
31 D11: =SUBTOTAL(9,D$2:D10)
31 D12: =SUBTOTAL(9,D$2:D11)
 
Back
Top