Home |
Search |
Today's Posts |
#1
|
|||
|
|||
totaling figures in colum
When I use the formula to total a colum of monatary numbers in a colum as an
example =sum(e3:e166) I get a total but if I insert another figure in a blank space within those limits it doesn't add it in the total. What am I to do so it automatically adds it to the total? I really appreciated the answer you gave me to my previous question. Thanks again |
#2
|
|||
|
|||
Hi Bedros,
Try: Tools | Options | Calculation | select Automatic --- Regards, Norman "Bedros" wrote in message ... When I use the formula to total a colum of monatary numbers in a colum as an example =sum(e3:e166) I get a total but if I insert another figure in a blank space within those limits it doesn't add it in the total. What am I to do so it automatically adds it to the total? I really appreciated the answer you gave me to my previous question. Thanks again |
#3
|
|||
|
|||
Perhaps you need to turn on Automatic Calculation under
Tools--Options--Calculation. Or perhaps your blank cells are being seen as text. To find out, see "Data Isn't Recognized..." http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Bedros" wrote in message ... When I use the formula to total a colum of monatary numbers in a colum as an example =sum(e3:e166) I get a total but if I insert another figure in a blank space within those limits it doesn't add it in the total. What am I to do so it automatically adds it to the total? I really appreciated the answer you gave me to my previous question. Thanks again |
#4
|
|||
|
|||
Thanks a million Anne Troy, that was the answer and I'm very grateful. I was
going crazy. I'm new at this and old . Sincerely, Bedros "Anne Troy" wrote: Perhaps you need to turn on Automatic Calculation under Tools--Options--Calculation. Or perhaps your blank cells are being seen as text. To find out, see "Data Isn't Recognized..." http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Bedros" wrote in message ... When I use the formula to total a colum of monatary numbers in a colum as an example =sum(e3:e166) I get a total but if I insert another figure in a blank space within those limits it doesn't add it in the total. What am I to do so it automatically adds it to the total? I really appreciated the answer you gave me to my previous question. Thanks again |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto sum does not add inserted figures in colum | Excel Worksheet Functions | |||
Calculate minus figures only | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Check data on colum A and find match on colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) |