Sum based on criteria

[thomasgibbini]

Hello,

How can I group/sum 2 columns (Qtd and Sum)  based on first column criteria ? 

For example for the first row I have to sum/group the quantity and the values of account 3011 + 3016 and for the next row 3012+3017 and so on as picture below.

Thanks in advance.

[BS_THE_ANALYST]

.

[BS_THE_ANALYST · Accepted solution]

@thomasgibbini actually think I had a logic flaw on previous response, ignore that one. I think this is closer to what you're looking for:

[thomasgibbini]

That worked. Thanks a lot :)