Sum Product - Error

[Nitin Shardul]

Sir,
Please check the attached file
Thanks
N3

 

[siva97237]

=SUMPRODUCT(($A$4:$A$75=$R4)*($B$4:$B$75=$S4)*($C$3:$M$3=$T4),C$4:M$75)
Try it in U4 and copy towards down

 

[blazy]

Hello,

you could use INDEX/MATCH in these one:

try below array formula (ctrl+shift+enter) in U4:

=INDEX($C$4:$M$75;MATCH(R4&S4;$A$4:$A$75&$B$4:$B$75;0);MATCH($C$3:$M$3;$T4;0))

KR

 

[Somendra Misra]

Hi,

You can also try in U4 and copy down:

=SUMPRODUCT(INDEX($C$4:$K$40,,MATCH(T4,$C$3:$K$3,0))*(S4=$B$4:$B$40)*(R4=$A$4:$A$40))

Regards,

 

[John Jairo V]

Hi to all!

Two more options:
=INDEX($C$4:$K$40,MATCH(R4&S4,INDEX($A$4:$A$40&$B$4:$B$40,),),MATCH(T4,$C$3:$K$3,))

=SUMIFS(INDEX($C$4:$K$40,,MATCH(T4,$C$3:$K$3,)),$A$4:$A$40,R4,$B$4:$B$40,S4)

Blessings!

 

[blazy]

Hey,

these different approaches are awesome

I made a typo in my formula, the right INDEX/MATCH formula is:

=INDEX($C$4:$M$75,MATCH(R4&S4,$A$4:$A$75&$B$4:$B$75,0),MATCH(T4,$C$3:$M$3,0))

KR

 

[Nitin Shardul]

=SUMPRODUCT(($A$4:$A$75=$R4)*($B$4:$B$75=$S4)*($C$3:$M$3=$T4),C$4:M$75)
Try it in U4 and copy towards down

Thanks it Works

 

[Nitin Shardul]

Hi to all!

Two more options:
=INDEX($C$4:$K$40,MATCH(R4&S4,INDEX($A$4:$A$40&$B$4:$B$40,),),MATCH(T4,$C$3:$K$3,))

=SUMIFS(INDEX($C$4:$K$40,,MATCH(T4,$C$3:$K$3,)),$A$4:$A$40,R4,$B$4:$B$40,S4)

Blessings!

Thanks it Works

 

[Nitin Shardul]

Hi,

You can also try in U4 and copy down:

=SUMPRODUCT(INDEX($C$4:$K$40,,MATCH(T4,$C$3:$K$3,0))*(S4=$B$4:$B$40)*(R4=$A$4:$A$40))

Regards,

Thanks 4 the Help
N3