Help please with selective formula?

Hi,
This is my first post and I openly admit I have no knowledge of formulae. I would therefore really appreciate some help organizing my monthly budget statement to make life easier.

I don't know why but the upload button doesn't appear to do anything so I'm unable to upload my worksheet. I've therefore attached a partial image instead.

test.jpg

From the image of the worksheet I’m asking if there is a formula that could be placed into I 4 that would extract the sum total of all the items of the same name in the “Description” column, and also place it’s "Transaction Type" name in G 4?

Ditto for all the others.

For example: all TNI’s would result a total of: £69.15 in I 4 and it’s type “Contactless Payment” in G4.

I hope that's clear and many thanks in advance.

Hello and welcome to the forum.

Try these:

G2 =INDEX(B:B,MATCH(H2,C:C,0))

I2 =SUMIF(C:C,H2,D:D) Assuming that you're only looking to sum the "Paid out" column.

Drag both formulas down.

You're welcome. Happy to help.