![]() |
#2
|
||||
|
||||
![]()
Try:
Code:
=SUMIFS(CODES!D$2:D$34,CODES!$C$2:$C$34,$B3) copied down and across. or if you need to also match the column headers because they may not be in consistent order, then Code:
=SUMIFS(INDEX(CODES!$D$2:$F$34,,MATCH(C$2,CODES!$D$1:$F$1,0)),CODES!$C$2:$C$34,$B3) |
Tags |
sum vlookup formula |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging 2 different cells containing IF formula & change in cell values based on multiple time frame | jay_excel | Excel | 0 | 07-29-2017 11:04 PM |
Index to return value based on 2 conditions | george batshon | Excel | 2 | 01-28-2017 05:11 AM |
![]() |
danigirl121 | Excel | 7 | 06-08-2016 01:57 PM |
Excel Formula for Multiple Conditions & Results | nowco | Excel | 4 | 03-16-2016 11:24 AM |
![]() |
nitemath2 | Excel | 1 | 06-19-2015 01:28 AM |