| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding cells but leaving blank if not populated
Replace OR with AND
=IF(AND(C5="",D5="",E5="",F5="",G5="",H5="",I5="") ,"",(C5+D5+E5+F5+G5+H5+I5)) 'Using SUM() =IF(SUM(C5:I5),SUM(C5:I5),"") If this post helps click Yes --------------- Jacob Skaria "Scoober" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding cells but leaving blank if not populated
=IF(COUNT(C5:I5),SUM(C5:I5),"")
-- David Biddulph Scoober wrote: 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? |
| Reply |
| 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 | |||
Linear Mode
