Average If formula
Looking for help with an average function if anyone can help, we have a column with a company name (SI Team) and a column for response time (this gives number of days). Looking help with a formula to count up and average all the response times IF the company name is ABC. Help is greatly appreciated. I think it might need to be a SUMIF and COUNTIF function.
=SUMIF([SI Team]:[SI Team], "ABC", [Response Time]:[Response Time])) / COUNTIF([SI Team]:[SI Team], "ABC")
Thanks in advance
Help Article Resources
Check out the Formula Handbook template!