Home |
Search |
Today's Posts |
#1
|
|||
|
|||
When I SUM cells & 1 is empty I need the result to be empty not 0
I am summing up cells from two different sheets (1, 2) onto a third. Some of
the cell values on the first two sheets may not have anything in them, yet when I type in my formula on the 3rd sheet to sum the cells, I get a 0 value. The project I am working on has values of 0, 1, 2, and 3, so when there is a missing value I need to know about it (I do not know how to get Excel to do this - get no value, not even 0 in the results). Yet, right now when there is a missing value, I get a result of 0, which is confusing since that is one of the values I am interested in. Any help? Does this make sense? |
#2
|
|||
|
|||
You can check the value of the cells you are summing before going ahead with
the calculation. So you could change the formula: =Sheet1!A1+Sheet2!A1 to: =IF(OR(Sheet1!A1<"",Sheet2!A1<""),Sheet1!A1+Shee t2!A1,"") Hope this helps Rowan "Maribel" wrote: I am summing up cells from two different sheets (1, 2) onto a third. Some of the cell values on the first two sheets may not have anything in them, yet when I type in my formula on the 3rd sheet to sum the cells, I get a 0 value. The project I am working on has values of 0, 1, 2, and 3, so when there is a missing value I need to know about it (I do not know how to get Excel to do this - get no value, not even 0 in the results). Yet, right now when there is a missing value, I get a result of 0, which is confusing since that is one of the values I am interested in. Any help? Does this make sense? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display empty cells | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Matrix multiplication with empty cells | Excel Worksheet Functions | |||
How to make empty cells as zero in excel add-ins for SQL Server an | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions |