S
Scoober
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?
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?