SumIf Index Match - 4 conditions (failing miserably! :(

All

Does anyone know how I could build another condition into the following:

=SUMIF(MATRIX!M:M,C12,INDEX(MATRIX!BD:CN,0,MATCH(D3&D4,MATRIX!BD:CN&MATRIX!BD:CN,0)))

It works for 3 conditions

Condition 1. Built into the SumIf (column value)
Condition 2&3: Built into the Match (both matches across rows)

Simply I need to pick a column to sum if 4 cells have specific values.

Of these cells, 2 are row values, 2 are column values

I was thinking that someone may be able to tell me that its an issue with how I have put together the match formula without me having to scale down the spreadsheet and try to get it in a condition to attach here.

My formula works well with 3 conditions in the match, but fails miserably if I attempt to add another one or it brings back something random!

Other combinations:

=SUMIF(MATRIX!M:M,C12,INDEX(MATRIX!BD:CN,MATCH(D3&D4,MATRIX!BD:CN&MATRIX!BD2:CN,0),MATCH(C4,MATRIX!K:K,0)))
(This calculates although bummed if I know exactly what its calculating!)

=SUMIF(MATRIX!$M$1:$M$1999,$C12,INDEX(MATRIX!$BD$1:$CN$1999,MATCH(1,(C4=MATRIX!K:K)*(D$3=MATRIX!$BD$1:$CN$1)*(D4=MATRIX!BD:CN),0)))
(just brings back a 0 - but hey at least its not an error!)

What I have tried
Almost every version of a sumproduct I can think of, multiplying the matches.......

ANY HELP WONDERFULLY APPRECIATED

THANKS ALL

K

Probably you get better help with your question if you add an SMALL excel file, without confidential information.

Please also add the desired result.

with a pivot table.

I used sum and count to give you an idea.

See the attached file.