I don't know how your data is laid out, but here's one way

A B
1 Abe $1
2 Betty $2
3 Abe $3
4 Betty $3
5 Sam $2
6
7 Abe =SUMIF($A$1:$A$5,A7,$b$1:$b$5)
8 Betty copy
9 Sam down

HTH

"avensrose" wrote:

I have a spreadsheet with many employees and their expenses. I am looking
for a formula that finds the employees and adds up their expenses.