Hi there,
I have the following data in a tool I'm building (number of cases completed and average turnaround time for every day)
Date Cases Completed Turnaround Time
3/13/2017 165 10.05031447
3/14/2017 182 9.350649351
3/15/2017 71 10.3877551
3/16/2017 215 8.701086957
3/17/2017 157 9.614814815
3/18/2017 19 9.294117647
3/20/2017 210 10.5
I would like to be able to see the weighted average turnaround days for the week selected by the user, i.e. the weighted average turnaround time for the week of March 13th-17th. There doesn't seem to be a SUMPRODUCTIF function...any ideas on what would work?
Any help is much appreciated!!
Bookmarks