Will try to explain better, have included 2 graphics so that the general gist can be obtained, hard to supply
a graphic that I'm allowed to...
Weekly Graphic:
Files are placed each day into the appropriate column (file count changes daily)
Files are totaled each day in the Blue line at bottom and placed into the green line
At end of week, all the weekly files are totalled (number under the green at bottom)(52)
That number (52) is transferred to and added to the year to date total on Year to date (Master) Sheet
(This is dynamic, and the master sheet total (B17) changes each day)
What I am looking for to do is to provide a weekly average for the specific week (38,39,40 etc)
and place it either beside the weekly total or monthly total (cell placement doesn't matter, can be any cell)
So the formula when trying to do this is:
(B17 is the cell number where the year to date number is on the Master sheet)
when I choose a blank cell on the weekly sheet and use the formula
='2022 Master'!B17/39 it should place the result of the number in the cell
from my understanding, that formula is supposed to take the large number on the Master sheet at B17 and divide it by the week number (39) to get an average for the week.
All it gives me is a date and not even todays date...
The weekly average now needs to be included with each week, so if there's a simpler way to do this, then I'm all ears
some formula that will take the master sheet year to date files number and divide by the corresponding weekly number (38, 39,40 etc)
if I have to place this in a cell for each week then fine, but thought there was a better way, because there's always a better way right?
Currently VB is not an option, so for now it's manual....