What is wrong with this formula? =AVERAGE(E8:AH8)*.0.33, IF(E3:AH3, "HW")
E Elkar Dec 30, 2005 #2 I think this might get the results you're looking for: =(SUMIF(E3:AH3,"=HW",E8:AH8)/COUNTIF(E3:AH3,"=HW"))*0.33 HTH, Elkar
I think this might get the results you're looking for: =(SUMIF(E3:AH3,"=HW",E8:AH8)/COUNTIF(E3:AH3,"=HW"))*0.33 HTH, Elkar
