Averageif Formula

Rahul Bhandari

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.

Thanks

Paul Newcome

Your syntax is a little mixed up. Try this...

=AVERAGEIF({Table 1 Range 1}, "France", {Table 1 Range 12})

Paul Newcome

Your syntax is a little mixed up. Try this...

=AVERAGEIF({Table 1 Range 1}, "France", {Table 1 Range 12})

Rahul Bhandari

Thanks Paul

Paul Newcome

Happy to help! 👍️