We need the exact layout of your data in order to help... What data is in
which columns...
--
HTH...

Jim Thomlinson


"avensrose" wrote:

That helps alot, but I have more than one column to find and add. I can get
it to work with one column, but when I add more columns I get an error.

"pdberger" wrote:

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.