| 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 | |||
Linear Mode
