Combining IF and AVG help
I am trying to combine these two functions to find an average number but only if it meets a specific criteria. For example, I have cases worked that can be canceled for 3 reasons. If the case is canceled because of a "No contact" with the client, I need to know the average number of days the case was active before it was canceled.
I've tried 7 different degrees of IF/AVG formulas to no avail. It either comes back as unparseable or invalid data type.