• 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.

Sumproduct with Rank multiple criteria

Biplab4444

New Member
Hi All,

Can you please help me on the same, file has attached. I have put a formula but it shown wrong result.

Month Name Year Units
January Amar 2013 12
February Akbar 2012 45
March Amar 2013 67
January Anthony 2013 34
March Amar 2012 89
February Akbar 2012 222
March Amar 2012 343
March Amar 2012 111
January Amar 2013 45
January Amar 2013 111
February Akbar 2012 34
February Akbar 2012 123

This is my Table I want to calculate
Month Name Year Top Result
February Akbar 2012 3 ??

Correct Answer should be 390 (222+123+45)
Without any helper column.
 

Attachments

  • Sumproduct with Rank multiple criteria.xlsx
    11.9 KB · Views: 10
Back
Top