Match values between columns

[hak2016]

Hi there.

So, I get the following situation:

LINK TO IMAGE

I need to see all the values on column D (specific transactions ID) on column A (Transaction ID) so I can sum the amounts and get a total from the specifics transactions. I already tried conditional formatting for highlighting all the matches between columns A and D, but my PC simply is not fast enough to filter only the highlights so I can add them.

Any ideas?


thank you?

 

[Marcelo Branco]

Welcome to Mr Excel

Assuming TRANSACTIONS ID in A2:A100; Amount in C2:C100; SPECIFIC TRANSACTIONS IDS in D2:D64, maybe this

=SUMPRODUCT(SUMIF(A2:A100,D2:D64,C2:C100))

Adjust the ranges to suit.

Hope this helps

M.

 

[Marcelo Branco]

@hak2016

I tried to reply to your Private Message but to no avail. I received this error message
"hak2016 has exceeded their stored private messages quota and cannot accept further messages until they clear some space."

Try to delete some messages.

M.

 

[hak2016]

Yeah, I noticed you're from Rio and I'm from São Paulo so I sent you a message in pt-br to say your formula worked like a charm. Thank you so much, sir!

Also, if it isn't much to ask for, could you explain your logic to determine this formula and how it works?

Thanks again!