Hey guys,
I would really appreciate some help from you. I am currently trying to make an SUMIF function but with no luck so far.
The goal is: In "Column A" I have account numbers which tend to repeat so the rows in that column looks like:
A B
22 15
22 17
22 22
22 8
31 2
31 9
...
I would like to make a code which would do this:
A B
22 62
31 11
So it would simply remove duplicates from Column A and then sum up values in Column B based on Column A (Simple SUMIF in excel).
Any help would be appreciated.
Thanks.
Solved! Go to Solution.
Thank you 🙂