Thread: how to compute a range of cells based on another range of cells?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
B. R.Ramachandran
 
Posts: n/a
Default 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")
Reply With QuoteReply With Quote