Dear friends and respected seniors
I have this data starting from cell a1
I am comparing the contents of column A and summing up similar data from column BPlease Login or Register to view this content.
a1 and a2 has A, hence 2+3 = 5,
a3, a4 and a5 have B, hence 6+4+2 = 12,
a6, a7 and a8 have C, hence 1+(-6)+2 = -3, and so on
in c1 I have used this formula and dragged down till c8
the answers are correct, but that is not the output that i wantPlease Login or Register to view this content.
In column D, i have entered the required output manually
Can anyone please kindly help me with this problem
Awaiting your replies.
Thank you.
I have posted this question here too
mrexcel.com/forum/excel-questions/1071886-sumif-problem.html
Bookmarks