Hello,

I have two columns.
A contains an ID number (could have duplicates throughout the rows)
B contains a payble amount

In A column there are duplicate entries but could have different payble
amounts (clumn B).

I need to add all the amounts per ID number (unique and/or duplicate).

Any suggestions?