When I add numbers in a column, sometimes I'm not getting the correct total.
I've cleared the cells of all formuals, and have re-entered the SUM formula
(sometimes clicked the icon) and still nothing. To test for accuracy, I will
delete a number and the total may or may not change. My workboods has about
30-40 sheets, so testing and totalling every sheet after every entry would be
very time-consuming.

Please post your formula thanks

"websterk12" wrote:

When I add numbers in a column, sometimes I'm not getting the correct total.
I've cleared the cells of all formuals, and have re-entered the SUM formula
(sometimes clicked the icon) and still nothing. To test for accuracy, I will
delete a number and the total may or may not change. My workboods has about
30-40 sheets, so testing and totalling every sheet after every entry would be
very time-consuming.

Sounds like some of your numbers are actually TEXT. The SUM function ignores
text.

--
Biff
Microsoft Excel MVP


"websterk12" wrote in message
...
When I add numbers in a column, sometimes I'm not getting the correct
total.
I've cleared the cells of all formuals, and have re-entered the SUM
formula
(sometimes clicked the icon) and still nothing. To test for accuracy, I
will
delete a number and the total may or may not change. My workboods has
about
30-40 sheets, so testing and totalling every sheet after every entry would
be
very time-consuming.

The formula is: sum(g11:g30). It shows correctly in the formula bar but
still does not calculate correctly.

"Eduardo" wrote:

Please post your formula thanks

"websterk12" wrote:

When I add numbers in a column, sometimes I'm not getting the correct total.
I've cleared the cells of all formuals, and have re-entered the SUM formula
(sometimes clicked the icon) and still nothing. To test for accuracy, I will
delete a number and the total may or may not change. My workboods has about
30-40 sheets, so testing and totalling every sheet after every entry would be
very time-consuming.

I tried clearing the cells of all functions/contents/formulas and then trying
to sum the column...still nothing. How can I tell if the numbers are being
read as TEXT?

"T. Valko" wrote:

Sounds like some of your numbers are actually TEXT. The SUM function ignores
text.

--
Biff
Microsoft Excel MVP


"websterk12" wrote in message
...
When I add numbers in a column, sometimes I'm not getting the correct
total.
I've cleared the cells of all formuals, and have re-entered the SUM
formula
(sometimes clicked the icon) and still nothing. To test for accuracy, I
will
delete a number and the total may or may not change. My workboods has
about
30-40 sheets, so testing and totalling every sheet after every entry would
be
very time-consuming.

Are the numbers manually entered or are they the results of other formulas?

--
Biff
Microsoft Excel MVP


"websterk12" wrote in message
...
I tried clearing the cells of all functions/contents/formulas and then
trying
to sum the column...still nothing. How can I tell if the numbers are
being
read as TEXT?

"T. Valko" wrote:

Sounds like some of your numbers are actually TEXT. The SUM function
ignores
text.

--
Biff
Microsoft Excel MVP


"websterk12" wrote in message
...
When I add numbers in a column, sometimes I'm not getting the correct
total.
I've cleared the cells of all formuals, and have re-entered the SUM
formula
(sometimes clicked the icon) and still nothing. To test for accuracy,
I
will
delete a number and the total may or may not change. My workboods has
about
30-40 sheets, so testing and totalling every sheet after every entry
would
be
very time-consuming.

In a helper column enter =ISNUMBER(G11) and copy down.

See what's TRUE or FALSE just for the heckuvit.

Simply re-formatting will not change the FALSEs to TRUEs

Format all to General then select an empty cell.

Select G11:G30 and EditPaste SpecialAddOKEsc


Gord Dibben MS Excel MVP

On Wed, 24 Jun 2009 12:36:02 -0700, websterk12
wrote:

I tried clearing the cells of all functions/contents/formulas and then trying
to sum the column...still nothing. How can I tell if the numbers are being
read as TEXT?

"T. Valko" wrote:

Sounds like some of your numbers are actually TEXT. The SUM function ignores
text.

--
Biff
Microsoft Excel MVP


"websterk12" wrote in message
...
When I add numbers in a column, sometimes I'm not getting the correct
total.
I've cleared the cells of all formuals, and have re-entered the SUM
formula
(sometimes clicked the icon) and still nothing. To test for accuracy, I
will
delete a number and the total may or may not change. My workboods has
about
30-40 sheets, so testing and totalling every sheet after every entry would
be
very time-consuming.