formula returning incorrect blanks
in case anyone has a similar problem, I got this suggestion from Dave
Peterson and it works perfectly!
=if(count(sh12:ch14)0,sum(ch12:ch14),"")
the 0 can be replaced with whatever number you want before a summation
is done (i.e. 1 value, 2 values, etc. present)
|