Sumifs where one criteria range is on Column and the other on Row

[Venkata Ramanaji]

Hi

Please find the attached file wherein data is required in the yellow cells.

Regards
Ramana

 

[coolkiran]

Hi Ramana

You can use Sum Product. I have updated in the attached file.

=SUMPRODUCT(($C$2:$Q$2=C14)*($B$3:$B$9=B14)*($C$3:$Q$9))

 

[rahulshewale1]

Hii @Venkat,


Try below formula,


Cell D14 :


=INDEX($C$3:$Q$9,MATCH(B14,$B$3:$B$9,0),MATCH(C14,$C$2:$Q$2,0))



Regard
Rahul shewale

 

[Khalid NGO]

Hi,

Or this:

=SUMIF($C$2:$Q$2,C14,INDEX($C$3:$Q$9,MATCH(B14,$B$3:$B$9,0),))

Regards,

 

[bosco_yip]

Or……………..

=IFERROR(VLOOKUP(B14,B$3:Q$9,MATCH(C14,B$2:Q$2,0),0),0)

Regards
Bosco

 

[Venkata Ramanaji]

Hi Everyone

Thank you very much.

Regards
Ramana