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

D

Duke Carey

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
 
B

B. R.Ramachandran

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
 
Top