This may be a little convoluted, so I ask that you bear with me. I'm working on a worksheet to track budget expendiatures. I've divided it into columns of Date Ordered, Supply Category, Amount Ordered, Amount Approved, and Running Approved Total (by supply category).

So we can order multiple supply categories (1, 2, 3) on the same day. What I was looking to do was to automatically calculate the Running Approved Total so I'm looking for a formula that does the following things:

- Searches for the first instance of an order in this category
- Identifies if this is the first instance and, if so, just mirrors the Amount Approved for that day
- If NOT the first instance, searches for the last Running Approved Total for that category and adds today's amount approved to the running total.

If you have questions, please don't hesitate to ask. This has been bugging me for going on one week.

-G