| 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)*.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?
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, "HW") 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 "HW" to appear at the end of the result, but only under certain circumsatnce? A little color will help us help you "HAROLD" wrote: What is wrong with this formula? =AVERAGE(E8:AH8)*.33 IF (E3:AH3, "HW") |
|
#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") |
| 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 | |||
Hybrid Mode
