=IF(COUNT(A3,A7,A11)=0,"",SUM(A3,A7,A11)/COUNT(A3,A7,A11))
I'm having a problem with trying to get the correct percentage using this
formula. It works fine as long as there are 3 values in the corresponding
cells but sometimes there is a "0" value in 1 or 2 or 3 of the corresponding
cells. I need it to divide by 3 if there are 3 values, divide by 2 if there
are 2 values, and divide by 1 if only 1 value. Thanks in advance, I'm really
confused!!