Average If Unpareseable

Joseph Sorrells

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.

Heather Duff

Hi Joseph,

Try this:

=AVERAGEIF({Customer Support Range 1}, "IT Request", {Support_Case Age})

Let me know if it works!

Best,

Heather

Heather Duff

Hi Joseph,

Try this:

=AVERAGEIF({Customer Support Range 1}, "IT Request", {Support_Case Age})

Let me know if it works!

Best,

Heather

Joseph Sorrells

This works perfectly thank you Heather!