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