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