How to pick sum range

[Ratan Bhushan]

Hi Guys
I have few columns named "x,y,x" and rows names "a,b,c,d" but name is rows are repetative. I need to calculate sum of range selected in my sheet below.
Please help me guys.
Thanks
Ratan Bhushan

 

[Asheesh]

Hi Ratan -

Use the below formula in C14 of your file

SUMPRODUCT(($B$2:$D$10)*($B$1:$D$1=$C$12)*($A$2:$A$10=$C$13))

 

[Hui]

Refer: http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/