unsure how to wite IF formula

**oceanside** · 01-14-2013, 08:53 PM

This question is similar to my last one. How do I write the formuanother IF formulala for d21 to add all cells from d5 thru d20, but not show a zero in d21 prior to entering values to be added. My last question was for a product formula and this board gave me an "if" formula. I'm guessing this is basically the same idea, but I don't know how to form it.

**vlady** · 01-14-2013, 09:04 PM

you can do it like

=if(sum(d5:d20)=0,"",sum(d5:d20))

or

if(countblank(d5:d20)=16,"",sum(d5:d20))

**Pete_UK** · 01-14-2013, 09:07 PM

Do you mean you want all the values in D5:D20 to be entered before the sum is made visible? If so, you can use this formula:

=IF(COUNT(D5:D20)=16,SUM(D5:D20),"")

If not, then perhaps you want the sum to show only after at least two numbers have been entered in your range, like this:

=IF(COUNTIF(D5:D20,"<>")>=2,SUM(D5:D20),"")

Hope this helps.

Pete