Sumifs using multiple criterias with criteria ranges spread across - Microsoft Community

which translate to =SUMIFS(INDEX($B$2:$D$5,,MATCH(J2,$B$1:$D$1,)),$A$ 2:$A$5,I2) in your case

Is this what you are looking for? Great if yes.

The problem there is that the duplicates are only in the column, and not across the row also. If there are duplicates across the column and row, as in my example above, then I (seriously) doubt SUMIFS alone can handle it.

Another way this can be done is using SUMPRODUCT. The advantage here is that it works equally well when there are duplicate column and row headers as when there are unique.

=SUMPRODUCT(($A$2:$A$12=I2)*($B$1:$F$1=J2),$B$2:$F $12)