Thanks so much!! Is there a way to not show the #DIV/0! if the results are 0,
I thought using the =0,"", would prevent that but it still shows. Thanks so
much for your help!!!



"Max" wrote:

One way:
=IF(COUNT(A3,A7,A11)=0,"",SUM(A3,A7,A11)/SUMPRODUCT((A30)+(A70)+(A110)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Richard" wrote:
=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!!