• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to Match Multiple Column Rows

sir,

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

Attachments

  • Familly Medicare.xlsx
    25.9 KB · Views: 7
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,
 
Sir,
Same Problem,
Tried but lacking somewhere attached file for your reference
Thanks
Nitin
 

Attachments

  • Sample file.xlsx
    43.4 KB · Views: 1
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
 

Attachments

  • Sample file (4).xlsx
    51.4 KB · Views: 1
  • n3sample.xlsx
    46.1 KB · Views: 1
Back
Top