SUMIFS using many rows and many coulmns

[w2x3y5z7]

SUMIFS using many rows and many coulmns
Hi Expert,

I have table and i need to sum the value with criteria from rows and cloumn
the data such like below :

sumifs.xlsx

criteria 1 A
criteria 2 Y
criteria 3 P

formula sumif but can not work
=SUMIFS(B3:C7,B1:C1,B11,B2:C2,B12,A3:A7,A13)

the i want to sum the value base on all 3 criteria, as i know it using "sumifs" but can't not work / error

i need your advice and suggestion please.

thanks in advance

Regards,

[jeffreybrown]

Please see the forum rules about cross posting...

If you do cross post, please set a reference to the other post...

http://www.mrexcel.com/forum/showthr...ighlight=sumif