Tracking totals over all sheets, but from different cells
Hi, I'm trying to keep an automated running total on working hours for my project. I have one sheet per day, each with a cell that sums the total hours for that day (reads 40 in my screenshot), dating back to October.
I've been tracking this manually with a rather bulky SUM function on a dedicated sheet, and it works just fine, but I'd like to try to automate the grand total to sum each day as it's created, rather than manually adding the cell each time I create a new sheet. The issue I'm running into is that the daily total doesn't land on the same cell every day; I am constantly adding & removing rows as people come & go from the project. There are also multiple cells that read total hours; one for the subcontractor sections, one for my own company's section, and the bottom one which sums the whole day - this is the one I'm trying to track.
Is there a way to filter for this cells contents on each sheet based on the Daily Total cell in the bottom right perhaps, even though they're not in the same row?
As an aside, I'm not allowed to change the layout to make this easier; this is a standard form at my company and the formatting needs to stay the same.
[link] [comments]
Want to read more?
Check out the full article on the original site