Hi, I would like to calculate an average of numbers against a group and week number
sample data below
Q1 Resolve Group Week
5 IT Support 1
4 IT Support 1
5 IT Support 1
1 IT Support 1
5 IT Support 2
3 IT Support 2
4 IT Support 2
8 IT Support 3
1 IT Support 3
8 IT Support 3
3 IT Support 4
5 IT Support 4
8 IT Support 4
May be make use of Averageifs function.
Formula suggestion based on assumption
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Thanks for the help, worked perfectly, didn't think to use average if statement!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks