Please help with formula for averages
I am trying to create an average using data in Multiple Colums columns in another sheet. I am not finding luck with the formulas I have tried so far using AVG(Collect) or Average and I've tried adding AND or OR statements. I know I am just entering them incorrectly but am unsure how to fix them.
What I am trying to do is get the average number of days tickets have been open for, for a specific assigned technician for tickets if = Completed OR Withdrawn. Eg Average # of days
Data is in multiple columns in another sheet titled ITS Consulting Formulas
Reference Data is
Assigned (Column title) = Paula Shaver
Status (Column title) = Completed OR Withdrawn
Time Ticket has been open (days) (Column Title) - This is a column of data that already had calculations indicating the # of business days each ticket has been open for regardless of their status.
Can somebody please help me. It would be greatly appreciated.
Thank you, Paula
Help Article Resources
Check out the Formula Handbook template!