Average If Unpareseable
My team wants to track the average day count that that a customer request has been open based on the request type.
My formula is:
=AVERAGEIF({Support_Case Age}, {Customer Support Range 1} = "IT Request")
What I want is the Average of the {Support_Case Age} column, if the value in the {Customer Support Range 1} is "IT Request".
Looking at the function syntax AVERAGEIF( range, criterion, [ average_range ] )
I believe my range should be
{Support_Case Age}
My criterion should be
{Customer Support Range 1} = "IT Request"
If the criterion is not met I do not want the entry counted so I believe the [ average_range ] should be left blank.
Thank you in advance for any help you can provide.
Best Answer
-
Hi Joseph,
Try this:
=AVERAGEIF({Customer Support Range 1}, "IT Request", {Support_Case Age})
Let me know if it works!
Best,
Heather
Answers
-
Hi Joseph,
Try this:
=AVERAGEIF({Customer Support Range 1}, "IT Request", {Support_Case Age})
Let me know if it works!
Best,
Heather
-
This works perfectly thank you Heather!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!