Sorting data using VLOOKUP, MATCH, INDEX etc.

Please do not specify the functions that you think you need to use in your thread title. It can be misleading and unhelpful to those trying to help you.

Use this formula in C4 and fill down to C32

=SUMIFS($AX:$AX,$AS:$AS,LOOKUP("zzz",$C$2:C$2),$AT:$AT,LOOKUP("zzz",$A$1:A$1),$AU:$AU,$A4,$AV:$AV,$B4,$AW:$AW,LOOKUP(6,$C$3:C$3))

Then copy C4:C32 and paste to F4, copy again and paste to I4, repeat accross to AK4.

Use the same formula in E4, changing the sum range from $AX:$AX to $AY:$AY, then fill down do E32, copy E4:E32 and paste to H4:H32, etc repeat to AM4.

For the bottom half of the table, start with this one in C37, then fill down and copy to the other columns as above, again changing the first range from AX to AY before filling the SE result columns.

=SUMIFS($AX:$AX,$AS:$AS,LOOKUP("zzz",$C$35:C$35),$AT:$AT,LOOKUP("zzz",$A$34:A$34),$AU:$AU,$A37,$AV:$AV,$B37,$AW:$AW,LOOKUP(6,$C$36:C$36))

Exactly what I was looking for. Thank you!