AverageIf Function Using Excel

Excel 2013, Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials

I’ve heard from several of you that use Excel to manage large sets of data nad I know hata few of you must then get different metrics from that data depending on specific conditions. I’ve already covered Sumif quite a bit so today I thought I’d get into “averageif”. Let’s start with a large set of data:

This is an example of the top rankings in the WTA tennis tour. One typical thing that you could end up wanting to do is find information such as:

-What is the average # of tournaments that the top Russians have played compared with the top Americans. Here is How I would do it:

I’m certain that many of you can now imagine how this could be used.


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


3 Feedbacks on "AverageIf Function Using Excel"

rickard engström icm

What’s up it’s me, I am also visiting this site daily, this site is truly nice and the people are actually sharing pleasant thoughts.

Markdonald Chinedu

Thank you

Funk Vinyl LP Shop

Funk Vinyl LP Shop…

Excel function tutorials | Experiments in Finance…


Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.