If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Consolidate excel 2007
I have cosolidated 26 sheets all in the same book with the sum function, top
row left column. Most of the consolidation worked OK but 4 totals are incorrect. I have checked that all the numbers to be totalled are in fact numbers. Please can you help -- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa |
#2
|
|||
|
|||
Consolidate excel 2007
Decimal display maybe?
-- Regards Dave Hawley www.ozgrid.com "Glenn" wrote in message ... I have cosolidated 26 sheets all in the same book with the sum function, top row left column. Most of the consolidation worked OK but 4 totals are incorrect. I have checked that all the numbers to be totalled are in fact numbers. Please can you help -- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa |
#3
|
|||
|
|||
Consolidate excel 2007
Thanks Dave. I have checked that all numbers are numbers using count and
numerical count. -- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa "ozgrid.com" wrote: Decimal display maybe? -- Regards Dave Hawley www.ozgrid.com "Glenn" wrote in message ... I have cosolidated 26 sheets all in the same book with the sum function, top row left column. Most of the consolidation worked OK but 4 totals are incorrect. I have checked that all the numbers to be totalled are in fact numbers. Please can you help -- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa |
#4
|
|||
|
|||
Consolidate excel 2007
If you have any other suggestions I would be most grateful. Very puzzled.
-- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa "ozgrid.com" wrote: Decimal display maybe? -- Regards Dave Hawley www.ozgrid.com "Glenn" wrote in message ... I have cosolidated 26 sheets all in the same book with the sum function, top row left column. Most of the consolidation worked OK but 4 totals are incorrect. I have checked that all the numbers to be totalled are in fact numbers. Please can you help -- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa |
#5
|
|||
|
|||
Consolidate excel 2007
How did you check that they were really numbers?
If you only checked the number format, then you didn't do enough. You can use: =isnumber(A1) to check a single cell or use: =count(a1:A10) and compare it with =counta(a1:A10) If both numbers match, then you have the same quantity of real numbers as you have entries. If this doesn't help, I'd look at the formulas again. Maybe you're missing some data: =sum(a1:A100) should be =sum(a1:a200) If this doesn't help, you may want to share the formula that worked and the formula that didn't. Glenn wrote: I have cosolidated 26 sheets all in the same book with the sum function, top row left column. Most of the consolidation worked OK but 4 totals are incorrect. I have checked that all the numbers to be totalled are in fact numbers. Please can you help -- With Appreciation Glenn Pinetown, KwaZulu Natal, South Africa -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|