| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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") |
| 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 | |||
Threaded Mode
