Using Lookup to add Multiple “lookup-value” data to reflect total.

[snmark]

Name Date Reason Amount
A 8/6/17 Rent/Bond $2,180.00
B 27/7/17 Gift $1,000.00
A 8/2/18 Rent $2,560.00
C
D
C
F
A 6/1/18 Gift $696.00

For instance, lookup all the values of A for a sum total. Is that possible with a VLOOKUP formular.?
Thanks
snmark

 

[sheetspread]

sumif

 

[snmark]

sumif

Thanks for that, can you explain how to use sumif in my example please.

 

[snmark]

Thanks sheetspread, I’ve worked it out, no need to reply.