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

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

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

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

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