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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!