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

Decimal display maybe?



--
Regards
Dave Hawley
www.ozgrid.com
"Glenn" <(E-Mail Removed)> wrote in message
news:12C0EBC1-03B6-4EF4-96DE-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> news:12C0EBC1-03B6-4EF4-96DE-(E-Mail Removed)...
> >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
>

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" <(E-Mail Removed)> wrote in message
> news:12C0EBC1-03B6-4EF4-96DE-(E-Mail Removed)...
> >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
>

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