Count cells from a specific row and then take an average

Hello all ,

What I am trying to do is look up a specific word in a column, then pull the value in the same row from another.. but then take an average of those numbers.


For example:

I want to know the average number of days for all CPSS, then average number of days for Internal etc.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!