SUMIF Function

[MiroPwC]

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.

[echuong1 · Accepted solution]

You can achieve this using a Summarize tool. 

Group by A and Sum B. 

See attached for an example. Let me know if that works!

[fmvizcaino · Accepted solution]

Hi @MiroPwC ,

For that, you can use the summarize tool as image below.

Best,

Fernando Vizcaino

[MiroPwC]

Thank you 🙂