Find Average Number if Criteria is Met


I need to determine the AVG number from a list of numbers if the Year and Week Number criteria are met.

For example, if the Year is 2025 (Year Column) and the Week Number is 1 (Week Number Column), I need the average number of days in the FO Node Upgrades Duration column.

I know that this formula =COUNTIFS({Year}, "2025", {Week Number}, "1" will narrow down the count to Year and Day of Week. But I'm not sure how to get the AVG number from the list in the FO Node Upgrades Duration column.

Thank you,

Mike Tuccillo


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!