Excel 2002: Why the first row of the subtotal table always not add

[Guest]

Dear Sir,

I try to use the Subtotal Function at Data > Subtotal and find that the
first row of the block of data (Cell D2) always not added. Surprisingly this
happens to other data table as well.

The grand total also short of the amount of the first cell that is omitted .

I highlight the data block in cell A2: D24 and follow the default
instructions on the dialog box to to get the folowing subtotal table

May I know why the amount 282.00 in cell D2 is not added and how to fix
this problem ? Can this due to a programing error in the Excel 2002
Spreadsheet ?

Thanks

Low

A B C
D
1 Client Ref Date Amount
2 PKHLA491 NK004150 14/08/2007 282.00
3 PKHLA491 NK004151 14/08/2007 672.00
4 PKHLA491 NK004156 14/08/2007 1,332.00
5 PKHLA491 Total 2,004.00
6 PKHLB821 NK004157 14/08/2007 120.00
7 PKHLB821 NK004158 14/08/2007 222.00
8 PKHLB821 NK004159 14/08/2007 112.80
9 PKHLB821 Total 454.80
10 PKHLD208 NK004165 14/08/2007 527.80
11 PKHLD208 NK004166 14/08/2007 338.80
12 PKHLD208 NK004167 14/08/2007 1,055.60
13 PKHLD208 NK004168 14/08/2007 527.80
14 PKHLD208 Total 2,450.00
15 PKHLA491 NK004169 14/08/2007 327.60
16 PKHLA491 NK004170 14/08/2007 201.60
17 PKHLA491 NK004171 14/08/2007 888.00
18 PKHLA491 Total 1,417.20
19 PKHLB821 NK004173 14/08/2007 222.00
20 PKHLB821 NK004174 14/08/2007 225.60
21 PKHLB821 NK004175 14/08/2007 222.00
22 PKHLB821 NK004176 14/08/2007 444.00
23 PKHLB821 Total 1,113.60
24 PKHLK941 NK004177 14/08/2007 1,190.00
25 PKHLK941 NK004178 14/08/2007 177.60
26 PKHLK941 Total 1,367.60
27 PKHLD208 NK004179 14/08/2007 183.60
28 PKHLD208 NK004185 14/08/2007 604.80
29 PKHLD208 NK004186 14/08/2007 201.60
30 PKHLD208 NK004187 14/08/2007 177.60
31 PKHLD208 Total 1,167.60
32 Grand Total 9,974.80

 

[Guest]

are you sure that d2 is a number and not text?
I can'r make it fail on my computer.

 

[Guest]

Hello bj,

I am very sure that D2 it is a number.

Kind Regards

Low

 

[Guest]

when you use subtotal, highlight the area from A1 to D24. I think there lies
the problem.

 

[Dave Peterson]

Put =isnumber(D2) in an empty cell.

Do you see True or False?

If you see False...
select D2
format|cells|general (or any number format--not text)
and retype that entry.

 

[Dave Peterson]

Ps. If that doesn't work, then post the formula that does the subtotal. Maybe
that cell isn't part of the range to be subtotaled?

 

[Guest]

in an empty cell enter
=d2+d3+d4 and see what you get
please paste the formula you have in D5
do you get any difference when you use 9 versus 109 in the function_num
position

 

[Guest]

looking at your post again, you say you selected A224 and did data-subtotal
It treated row 2 as a title row, so it would not add this to the subtotal
try selecting A1:d24 and see what happens
(In other words I feel Pranav is correct)

 

[Guest]

Helo bj,

Yes, you are right.

I need to highlight one more row above the foirst row of data to enable the
table to add corectly

I also have discoverd this by trial and error yesterday.

Thanks you anyway.


Low