Consolidate excel 2007

  • Thread starter Thread starter Glenn
  • Start date Start date
G

Glenn

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
 
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 said:
Decimal display maybe?
Click to expand...
 
If you have any other suggestions I would be most grateful. Very puzzled.
--
With Appreciation
Glenn
Pinetown, KwaZulu Natal, South Africa


ozgrid.com said:
Decimal display maybe?
Click to expand...
 
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.
 
Back
Top