Hi everyone, I'm using Excel 2013 and a little stumped. I have a weekly report I do to summarize inventory (I work for a bulk storage company, so we have product coming in and going out of tanks daily). I summarize this information by tank number and by week, month and YTD. Each week's information is listed on a separate sheet and that sheet is named the weekending date, for example today's report was on sheet named 09-18-2014, last weeks was 09-11-2014.
At the bottom of my report on the most recent sheet I have the totals
I'd show a screen shot but don't know how to post that on here, anyway this is what my summary looks like, I hope this makes sense, I've been manually adding to my sum formula in the monthly and YTD summary
<tbody>
</tbody>
At the bottom of my report on the most recent sheet I have the totals
I'd show a screen shot but don't know how to post that on here, anyway this is what my summary looks like, I hope this makes sense, I've been manually adding to my sum formula in the monthly and YTD summary
Tank 105 | Tank 106 | |
Opening Gauge | 30 ft 10 1/2 | 10ft 2 1/4 |
Opening Barrels | 50,550 | 13,000 |
Receipts | 10,000 | 5,000 |
Deliveries | 5,000 | 2,000 |
Closing Book | 55,550 | 16,000 |
Closing Gauge | 31ft 5 | 12ft 5 |
Closing Barrels | 56,000 | 15,500 |
Totals | Tank 106 (gain/loss) | Tank 106 (gain/loss) |
Weekly | 500 | -500 |
Monthly | 550 (adds weekly totals for month) | 550 (adds weekly totals for month) |
YTD | -750 (adds (weekly totals for year) | 250 (adds weekly totals for year) |
<tbody>
</tbody>