Quote:
Originally Posted by NBVC
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)
|
Thank you!
It works in the example workbook but if I use it in the actual document it only gives '0'.
The actual document is to large to upload here.
https://www.dropbox.com/s/9w3zkkvm55...1114.xlsx?dl=0
Does this work?