Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum/autosum not calculating correctly
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoSum not working correctly | Excel Discussion (Misc queries) | |||
Autosum Calculating Wrong | Excel Discussion (Misc queries) | |||
Formulas Not Calculating Correctly | Excel Worksheet Functions | |||
formula not calculating correctly | Excel Discussion (Misc queries) | |||
why isn't this formula calculating correctly? | Excel Discussion (Misc queries) |