Prev: Basic Question on autocomplete function
Next: Merge Cells
From: Glenn on 12 Apr 2010 05:27
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
From: ozgrid.com on 12 Apr 2010 05:31
Decimal display maybe?



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

From: Glenn on 12 Apr 2010 05:44
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" <Glenn(a)discussions.microsoft.com> wrote in message
> news:12C0EBC1-03B6-4EF4-96DE-EF05518F6222(a)microsoft.com...
> >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
>
From: Glenn on 12 Apr 2010 06:06
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" <Glenn(a)discussions.microsoft.com> wrote in message
> news:12C0EBC1-03B6-4EF4-96DE-EF05518F6222(a)microsoft.com...
> >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
>
From: Dave Peterson on 12 Apr 2010 08:36
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
 | 
Pages: 1
Prev: Basic Question on autocomplete function
Next: Merge Cells