I want to calculate how many overdue items are there looking back 12 months and create a rolling average
ROLLNG.PNG
I want to calculate how many overdue items are there looking back 12 months and create a rolling average
ROLLNG.PNG
perhaps you could use something like:
Formula:Please Login or Register to view this content.
I suspect your file is using tables so you can use structured references - e.g Tbl[field]
(if you don't use structured references then try to avoid using entire column references with COUNTIFS as it's not particularly efficient)
If you need more assistance I'd suggest posting back and attaching a file, as opposed to an image.
Thanks for replying.
I used structured references and my goal is to determine the number of overdue for each month.
I implemented the formula you suggested but I had no luck.I have uploaded the excel sheet.
.
Presumably you could add a formula to count the total in Col E then divide by 12 ?Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks