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. |
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. |
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. |
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. |
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. |
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. |
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. |
All times are GMT +1. The time now is 02:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com