sarahw2271
New member
- Joined
- Aug 20, 2014
- Messages
- 8
- Reaction score
- 0
- Points
- 0
I have a workbook with tons of sheets set up. Each week I do a report where I breakdown the amount we spent advertising our various events in a one page ad in a local alt weekly. So each week has it's own sheet within the workbook. Each event is assigned a job number (2 letters and 4 digits), which is entered in column A. The spend for each event is calculated in column I. I want to find out how to create a formula for determining how much I have spent on any given event to date (i.e. a separate sheet with a total for each job number that updates automatically every week when I do the breakdown. Please let me know if you have any idea how to do this. Example attachedView attachment Example.xlsx