software

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

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, quot;HWquot;)

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 quot;HWquot; to appear at the end of the
result, but only under certain circumsatnce?

A little color will help us help you

quot;HAROLDquot; wrote:

gt; What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, quot;HWquot;)

Hi,

Use one of the following formulas,

=SUMIF(E3:AH3,quot;=HWquot;,E8:AH8)*0.33/COUNTIF(E3:AH3,quot;=HWquot;)

=SUMPRODUCT(--(E3:AH3=quot;HWquot;),E8:AH8)*0.33/SUMPRODUCT(--(E3:AH3=quot;HWquot;))

Regards,
B. R. Ramachandranquot;HAROLDquot; wrote:

gt; What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, quot;HWquot;)