| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Product of 2 arrays based on criteria
I want to do a SUMPRODUCT of 2 arrays but only if the elements in the array
meet a criteria established by a thrid array. For example, consider the three arrays, where the top array is names, the second array is salary and the third is a percentage: Amy Sam Tim Bob Tim Amy Bob 200 300 100 300 100 200 300 .4 .3 .2 .2 .1 .1 .5 I want to be able to end up with a sumproduct associated with each name. Thus IF "Amy" SUMPRODUCT=100, IF "Tim" SUMPRODUCT=210 and so on. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to count unique values in excel based on multiple criteria | Excel Worksheet Functions | |||
| caluculate an average based on 2 criteria | Excel Discussion (Misc queries) | |||
| Locate a Cell based upon criteria | Excel Discussion (Misc queries) | |||
| SUMIF in multiple columns based on other criteria in Excel? | Excel Discussion (Misc queries) | |||
| Which Function(s) do I use? | Excel Worksheet Functions | |||
Threaded Mode
