| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average nesting within Sumproduct?
I'm bamboozled!...and would welcome assistance from someone with greater
understanding of nesting functions than I. I've got the first bit, but can't work out the next part: Part A: If the value in cell M24 is found in range A2:a500, and if the item code in range J2:J500 commences with "A", then sum the $values in range I2:I500 Part B: Return an average based on the values in range I2:I500 (which meet the above criteria) multiplied by the value in P24. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| nesting "and" in sumproduct function | Excel Discussion (Misc queries) | |||
| nesting "and" in sumproduct function | Excel Discussion (Misc queries) | |||
| Excel : Nesting of functions such as sumproduct and sumif | Excel Worksheet Functions | |||
| Sumproduct Average | Excel Discussion (Misc queries) | |||
| How do I nesting subtotal function within average function in Exc | Excel Worksheet Functions | |||
Threaded Mode
