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