| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to sum cells but not show zero if cells are blank?
Thanks for the speedy reply both!, it did help alot, but i have one other problem, i need the statement to be an or statement i.e =IF(SUM(P5:Q5)=0,"",SUM(R4-P5+Q5)) needs to be something like =IF(SUM(P4)=0,(IF(SUM(Q4)=0,"",SUM(R3-P4+Q4)))) but this returns a value FALSE, it needs to say if P4 is 0 then sum R3+Q4 or If Q4 is 0 then sum R3-P4 Or if there are values in both then R3-P4+Q4 and of course if there are no values in P4,Q4 then dont show zero! Phew! its clear as mud to me hope you can sort the muddle! regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=549933 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count blank cells that contain formula? | Excel Discussion (Misc queries) | |||
| Automatically add "0" to blank cells without a formula in the cel. | Excel Worksheet Functions | |||
| OFFSET to include blank cells | Excel Worksheet Functions | |||
| Want #VALUE! to show as blank cell | Excel Worksheet Functions | |||
| blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
