That makes sense.

Doug

wrote in message
oups.com...
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)