SumProduct for one criteria in row and another in column

[sunilbsrv2k]

Hi All,

I have a table with months in the top row; Locations in the first column. Corresponding numbers in the remaining cells of the table.

I am trying to do a Sumproduct to get the data for each Location for the required month.

For Example, sum of numbers from Bangalore for the month of May.

I'm using the formula : =SUMPRODUCT(((Leaders!BR238:BR300)="Bangalore")*((Leaders!BE238:BM238)="May")*(Leaders!BI238:BI300))

Its giving me #Value error.

Could you please help.
Thanks

 

[RoryA]

The last bit should be:

*(Leaders!BE238:BM300))

 

[sunilbsrv2k]

Ok... Thanks for your help… its working.