I have a file that's almost 3000 rows of data
I have attached a test file for the purpose of this request.
I am trying to figure out the average days overdue per department whose due dates have not already passed.test (1).xlsx
I have a file that's almost 3000 rows of data
I have attached a test file for the purpose of this request.
I am trying to figure out the average days overdue per department whose due dates have not already passed.test (1).xlsx
There is no column labeled Due Date in your sample. Does this refer to Target Date or Completion date?
Does already passed mean Due Date < Today, or is it a combination of the other headers?
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Sorry, result should be in column "O".
I have a formula in there but it is not giving me the correct answer.
Yes anything < TODAY that has a value in Column J
At the end of the day I would like Column "O" to report the average of Column J for a given region in Column A
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks