Hello,

I have a book of spreadsheets where each sheet is a month starting with June 2024. Within each sheet

Column A is “Date” consisting of daily dates (e.g., 07/01/2024) and then Column D is “Weekly Total (Direct)”, which is the sum total of direct clinical hours (column B) for 5 rows of individual dates (i.e., a work week). Essentially what I want is to have a formula that goes through all the monthly sheets and gives me a single average value of the weekly total values (Column D) but only up to the current date so the average does not get diluted by the empty premade sheets for the future. I hope this makes sense, thanks!

​Hello, I have a book of spreadsheets where each sheet is a month starting with June 2024. Within each sheetColumn A is “Date” consisting of daily dates (e.g., 07/01/2024) and then Column D is “Weekly Total (Direct)”, which is the sum total of direct clinical hours (column B) for 5 rows of individual dates (i.e., a work week). Essentially what I want is to have a formula that goes through all the monthly sheets and gives me a single average value of the weekly total values (Column D) but only up to the current date so the average does not get diluted by the empty premade sheets for the future. I hope this makes sense, thanks!  Read More

​