| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding cells but leaving blank if not populated
I am trying to add cells C5 thru I5 to populate J5, I would like J5 to remain
blank if no figures are entered into cell C5 thru I5 instead of having a zero I have tried the following: =IF(OR(C5="",D5="",E5="",F5="",G5="",H5="",I5=""), "",(C5+D5+E5+F5+G5+H5+I5)) But this formula only leaves a blank J5 and will not add (say) C5 and F5 if the other cells in the formula are empty. Where am I going wrong? -- Thanks in advance. Scoober |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving Cell Blank | Excel Worksheet Functions | |||
| Leaving Cell Blank. | Excel Worksheet Functions | |||
| Leaving a cell blank | New Users to Excel | |||
| Colouring Ranges & Leaving Cells Blank | Excel Discussion (Misc queries) | |||
| Leaving a cell blank. Not NA(), not "". | Excel Worksheet Functions | |||
Threaded Mode
