Adding cells but leaving blank if not populated

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?
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data from 1 sheet to the next 6
Excel 2003 Conditional Formatting w/ 3 Conditions and a value = to 2
Too many IF functions 3
If C2 is Sunday how do I make D 2 to the next day of the week 2
Help !!! 2
Isblank error 3
To combine various cell formulae in to the final cell 1
Sum cells based on number of months 6

Top