Appropriate Lookup Function

Hello!

I'm looking for someone to help me out constructing a formula. I'll lay it out as best I can. I am using Excel 2000 on Windows XP.

My spreadsheet is a simple array keeping track of my research group's receipts. It lists the date, amount, location, and person who received the receipt as the column headings. New rows are entered for each receipt.

What I am trying to do is have the spreadsheet automatically update how much cash an individual has spent as I enter in new rows (receipt information).

ie: How much money has Jon spent? -- And in some way LookUp all the rows with "Jon" as the person who got the receipt and track the total of all of them within the table. Without having to manually Sort the table each time I want to look it up.

Ideally, I would also like to be able to do this with location, as well. As in, how much has everyone spent at, say, "Starbucks"

Best,
Aik

Sounds like you could could use the SUMIF function. Something like this:

=SUMIF(D:D,F1,B:B)

where column D has the name of the person, F1 has the person's name in it, and column B has the amount of the receipt.

If that doesn't work, feel free to post your workbook.

much appreciated! worked like a charm. really owe you one.

No problem, glad it worked for you.

Originally Posted by aikido

much appreciated! worked like a charm. really owe you one.

hi would you mind posting ur solution for all to see.

thanks

Sure.

=SUMIF(E11:E156,"Jon",D11:D156)