There are a couple of possible solution depending on your specific needs. If
there is only one criteria the you can use a sumif formula something like
this...
=SumIf(A1:A10, "Jim", B1:B10)
To find instances of Jim in the range A1:A10 and sum the corresponding
values in B1:B10...

If you have more than one criterian then you would want a sumproduct
formula... More like this but with extra criteria...
=Sumproduct(--(A1:A10="Jim"), B1:B10)
--
HTH...

Jim Thomlinson


"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.