How to Match Multiple Column Rows

[Nitin Shardul]

sir,

Please find attached sheet, SumProduct formula worked but while dragging it is copying same numbers please check
Thanks
Nitin

 

[Somendra Misra]

Hi Nitin,

Try changing your formula in U4 as below and copy across and down.

=SUMPRODUCT(($A$4:$A$45=$S4)*($B$4:$B$45=U$3)*($C$3:$P$3=$T4),$C$4:$P$45)

Regards,

 

[Nitin Shardul]

Great
Thank You

 

[Somendra Misra]

You are Welcome!!!

Regards,

 

[Nitin Shardul]

Sir,
Same Problem,
Tried but lacking somewhere attached file for your reference
Thanks
Nitin

 

[Somendra Misra]

Hi Nitin,

See your file.

Regards,

 

[Nitin Shardul]

Hallo Sir,

Thanks for the revert.
The file you sent has an error please check I have highlighted showing duplicate.
also attached other file but in some cells formula working in some cells it is not
Please check.

Thanks
N3

 

[Somendra Misra]

Hi,

See this file.

Regards,