I keep a tracker for the business that updates annual leave booked on a weekly and quarterly basis. This is great for people to be able to see what they've taken and what is booked but I have been asked to show a running total (based upon the figures in this file) that shows a running total up to the current week.
I've played around with a few COUNTIF and date specific formulas (incorporating TODAY & WEEKNUM) but nothing seems to just work and show me the figure, up to the previous week, in cell N6. It should be showing 2196 and would update weekly adding in the next weeks figures (as these can be updated at short notice but need to be done before the next week starts)
Is this possible given the layout/format of the data and if so can anyone help?
Bookmarks