Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compute a range of cells based on another range of cells?
What is wrong with this formula? =AVERAGE(E8:AH8)*.0.33, IF(E3:AH3, "HW")
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to compute a range of cells based on another range of cells?
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 "HAROLD" wrote: What is wrong with this formula? =AVERAGE(E8:AH8)*.0.33, IF(E3:AH3, "HW") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formula is used for subtracting a range of different cells f. | Excel Worksheet Functions | |||
Sorting a range of cells that get value from other cells | Excel Discussion (Misc queries) | |||
adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
Count cells based on date range in another column | New Users to Excel | |||
How can I dynamically eliminate blank cells in a given range in E. | Excel Worksheet Functions |