|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 24th, 2009, 04:51 PM
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
June 24th, 2009, 05:21 PM
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
June 24th, 2009, 05:38 PM
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
June 24th, 2009, 08:33 PM
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
June 24th, 2009, 08:36 PM
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
June 24th, 2009, 09:29 PM
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
June 24th, 2009, 10:39 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
