Averageif Formula

Hello All,

I need your help to define a formula, I have Country column and Networkdays columns so I need to avg networkdays for the specific country. could you please help me.

I am using : =AVERAGEIF({Table 1 Range 12}, {Table 1 Range 1}, ="France")

But I am getting : Invalid operation so basically I am not able to give criteria as "country" to fetch out avg belongs to that country.

Here Table 1 Range 12} is Networkdays columns & Table 1 Range 1 is country column

Any alternatives are welcome.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!