Match Exact Table Data with Table 2

[adityanshardul]

Dear Sir,

Please find attached data, I have tried this = SUMPRODUCT(($B$17:$B$20=B4)*($C$17:$C$20=$D$2)*($D$16:$N$16=C4),$D$17:$N$20) which works but while coping the said formula in other cells it doesn't work.

Please Help

Thankss
N3

 

[Somendra Misra]

Hi N3,

Try =SUMPRODUCT(($B$17:$B$20=$B4)*($C$17:$C$20=D$2)*($D$16:$N$16=$C4),$D$17:$N$20)

Regards,

 

[adityanshardul]

Hi N3,

Try =SUMPRODUCT(($B$17:$B$20=$B4)*($C$17:$C$20=D$2)*($D$16:$N$16=$C4),$D$17:$N$20)

Regards,

Yes Sir,
It works checking where i made mistake.

Thanks a lot.

 

[adityanshardul]

Oh Ya
Got it (How to use $ column & rows)
Thanks
N3

 

[Somendra Misra]

Glad you slove it. Welcome back!!!

Regards,