how to compute a range of cells based on another range of cells?
 

What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, "HW")

how to compute a range of cells based on another range of cells?
 

Nothing wrong with the first part

=AVERAGE(E8:AH8)*.33

What in the world are you trying to do with the second part?

IF (E3:AH3, "HW")

Are you trying to append that to the first part? (If so, you cannot do it
the way you are trying to) Do you want an "HW" to appear at the end of the
result, but only under certain circumsatnce?

A little color will help us help you

"HAROLD" wrote:

What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, "HW")

how to compute a range of cells based on another range of cells?
 

Hi,

Use one of the following formulas,

=SUMIF(E3:AH3,"=HW",E8:AH8)*0.33/COUNTIF(E3:AH3,"=HW")

=SUMPRODUCT(--(E3:AH3="HW"),E8:AH8)*0.33/SUMPRODUCT(--(E3:AH3="HW"))

Regards,
B. R. Ramachandran


"HAROLD" wrote:

What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, "HW")