Subtotal Function

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?
 
F

Frank Kabel

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
 
C

Cynthia

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.
 
D

David McRitchie

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)
 
Top