|
|
#2
01-20-2017, 05:41 AM
|
|||
|
|||
Here's one way...
In I3 copied over and down... =SUMPRODUCT(--($C$3:$C$23=$H3),--($D$3:$D$23=I$2),$E$3:$E$23) Another option is to use a pivot table 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel - Index and Match Function ,First Second and Third Match | paulzy95 | Excel | 10 | 09-29-2016 10:46 PM |
| Vlookup and Match | ExcelVlookup | Excel | 4 | 06-22-2015 01:42 AM |
 vlookup or match
|
uhlersa | Excel | 2 | 12-04-2012 12:35 AM |
| Match Index with sumproduct/vlookup | angie.chang | Excel | 1 | 06-18-2012 08:47 AM |
|
Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Windows Vista 
Office 2007
Threaded Mode