I have Excel 2010- I odn't have the analyze-insert timeline- available. SO with that being said. I was wondering if there was a way to show how many jobs were completed within 1 weeks time. The week of course would begin on a Sunday and end on a Friday. I attempted to do this and I just couldn't get the actual number per week. Please anything at this point would be helpful. Please see the attached sample sheet.
Is this what your looking for?
I added week number in column J then totaled it by week in columns L and M. The week number lookups are in columns O and P.
That was awesome, thanks a bunch. Is there a way to group them by technician team and week?
Last edited by thursday140; 09-21-2016 at 08:34 PM.
Yes just add another condition to the countifs formula. See attached
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks