Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum error
I am summing a column of 5 numbers (ex. =SUM(D1:D5)) and the formula returns
zero. The formatting is number, when I try to add D1+D2+D3... and I get the same result, zero. When I highlight the cells the Sum number on the bottom right border gives the correct answer. Also, if I a sum formula and go into the formula on the edit bar on the top and hit enter (not changing anything but I have put the cursor in the edit bar on top) it returns zero, even when before it had the correct answer and nothing was changed. The cells D1:D5 are summing up numbers from other sheets. Please help me because I am going insane! Thank you SO MUCH!! MKL |
#2
|
|||
|
|||
are D1 to D5 in the same formula format of workbook from which copied
instead of copying from the original sheet just copy paste special-values and then operate for example d1=sum(a1:a5) in the original workbook in the new book a1 to a5 may be blank and so d1 may be 0 may be some such problem, I am not sure If I am wrong sorry -- remove $$$ from email addresss to send email =============================== Mac Landers wrote in message ... I am summing a column of 5 numbers (ex. =SUM(D1:D5)) and the formula returns zero. The formatting is number, when I try to add D1+D2+D3... and I get the same result, zero. When I highlight the cells the Sum number on the bottom right border gives the correct answer. Also, if I a sum formula and go into the formula on the edit bar on the top and hit enter (not changing anything but I have put the cursor in the edit bar on top) it returns zero, even when before it had the correct answer and nothing was changed. The cells D1:D5 are summing up numbers from other sheets. Please help me because I am going insane! Thank you SO MUCH!! MKL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore error msgs in formula references | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) |