**In this lesson, I’m going to be showing you how to:**

- Use the AVERAGEIFS function to work out the average results by using criteria’s from multiple columns

Download the Excel file below, and save it onto your computer. So you can complete this lesson with me.

**Go ahead, open the video below and watch the tutorial at your own pace**:

If I have not covered everything in this lesson, please leave a comment or your question below and I will get back to you. (you may have to scroll down past other lovely peoples comments)

Enjoyed this tutorial? Then please don’t forget to Like & Share with your family and friends on all the social media platforms, such as Facebook, WhatsApp and Instagram 🙂

Watch this tutorial directly on our **YouTube channel** and **Subscribe**

**Thanks for watching!**

## Do you want to learn to create your own website?

If you want to LEARN to create your own website like ours, then
**CLICK HERE** to join a learning platform for **FREE** and learn at your own pace with video tutorials. Once you’ve joined, we will see you on the other side to help you out too.

**CLICK HERE** to read our review about this amazing learning platform, if you want to know more.

## When you’re ready move onto:

**Lesson 62 – The AverageA function in Excel | Why and When to use the AverageA function in Excel**

## Or go back to:

**Lesson 60 – What is the AVERAGEIF function in Excel | How to insert the AVERAGEIF function in Excel?**

**Lesson 59 – FORMULATEXT function in Excel | Display formulas or functions of individual cells only**

**Lesson 58 – SUMIFS function in Excel to ADD multiple CRITERIONS from different columns**

**Lesson 57 – SUMIF function used to ADD up MULTIPLE different items in one column in Excel | SUMIF+SUMIF**

**Lesson 56 – SUMIF function in Excel | What it is & how to insert the SUMIF function in Excel?**

**Lesson 55 – COUNT function in Excel | COUNTA function in Excel | COUNTBLANK function in Excel**

**Lesson 54 – COUNTIFS function in Excel with 2 examples | How to use Data Filter in Excel**

**Lesson 53 – COUNTIF function used to COUNT MULTIPLE different items in a column in Excel | COUNTIF+COUNTIF**

**Lesson 52 – COUNTIF function in Excel | What it is & how to insert the COUNTIF function in Excel?**

**Lesson 51 – How to use FILTER DATA in Excel | Number Filters: Greater Than Or Equal To | Less Than**

**Lesson 50 – How to LINK data and ADD up cells from a DIFFERENT WORKBOOK in Excel**

**Lesson 49 – How to LINK data and ADD up cells from MULTIPLE different worksheets in Excel**

**Lesson 48 – How to Hide & Unhide Worksheets in Excel | Hide Worksheets, so it CANNOT be unhidden easily in Excel!**

**Lesson 47 – How to Hide & Unhide Rows & Columns in Excel | Hide & Unhide Multiples Columns & Rows in Excel**

**Lesson 46 – Find & Replace in Excel | What is Match Case & Match Entire Cell Contents in Excel**

**Lesson 45 – How to apply borders around and in-between cells in Excel | Difference between borders & Gridlines in Excel**

**Lesson 44 – Use the IF function to work out if you are over BUDGET or not in Excel**

**Lesson 43 – How to change a DATE to different FORMATS in Excel**

**Lesson 42 – How to set and print rows & titles automatically at the top of each page in Excel**

**Lesson 41 – How to display and print GRIDLINES and ROW & COLUMN HEADINGS in Excel**

**Lesson 40 – How to MOVE a chart to a new worksheet on its own in Excel | Name the new worksheet in Excel**

**Lesson 39 – How to insert a LINE chart with MARKERS in Excel | Select non-adjacent data in Excel**

**Lesson 38 – How to add DATA LABELS to charts in Excel | Change colour of pie-chart segments in Excel**

**Lesson 37 – How to CHANGE the CHART from one TYPE to another in Excel | Column chart to Pie chart in Excel**

**Lesson 36 – Best method to COPY a CHART to a new worksheet in Excel | Making sure data is LINKED with the new chart!**

**Lesson 35 – How to insert a NEW worksheet in-between 2 worksheets in Excel | Rearrange and Rename worksheets in Excel**

**Lesson 34 – What is the PLOT & CHART AREA on a chart in Excel | How to SHADE the plot area in a chart in Excel**

**Lesson 33 – How to insert an Embedded Clustered Column Chart in Excel | What is a Clustered Chart?**

**Lesson 32 – What is Scale to Fit in Excel | How to use Scale to Fit (shrink pages) in Excel**

**Lesson 31 – Relative OR Absolute references in Excel | Everything explained | Confusion solved!**

**Lesson 30 – Best method to format numbers to display as PERCENTAGES in Excel**

**Lesson 29 – Everything you need to know about ABSOLUTE cell references before replicating a formula in Excel**

**Lesson 28 – A simple DIVISION formula in Excel | How to DIVIDE in Excel**

**Lesson 27 – What is the thousand separator in Excel | How to use the thousand separator in Excel**

**Lesson 26 – Use the AUTOSUM button to quickly ADD up cells in Excel | What is the Autosum Button in Excel?**

**Lesson 25 – Everything you need to know about FREEZING PANES (rows & columns) in Excel | What is Freeze panes?**

**Lesson 24 – How to SORT data in ASCENDING order in Excel**

**Lesson 23 – Best techniques to widen columns & adjust the height of rows in Excel**

**Lesson 22 – How to RENAME a worksheet in Excel**

**Lesson 21 – How to COPY cells from one spreadsheet to another spreadsheet in Excel**

**Lesson 20 – How to select multiple NON-ADJACENT cells in Excel | What are the benefits?**

**Lesson 19 – What is a Workbook and Worksheet in Excel | What is the difference between a workbook and worksheet in Excel?**

**Lesson 18 – What is a Formula and Function in Excel | What is the difference between a formula and function in Excel?**

**Lesson 17 – How to PRINT the spreadsheet SHOWING the formulas and functions in Excel**

**Lesson 16 – What is Page Orientation in Excel | Change Portrait orientation to Landscape in Excel**

**Lesson 15 – Format the Font colour in Excel | Shade a range of cells to any colour in Excel**

**Lesson 14 – How to insert a HEADER in Excel? | How to insert an AUTOMATIC FILENAME in the header?**

**Lesson 13 – How to Format cells as Currency (£) and apply 2 Decimal places to numbers in Excel?**

**Lesson 12 – What is the Wrap Text feature, and how to apply it in Excel?**

**Lesson 11 – What is the Merge & Center feature, and how to apply it in Excel?**

**Lesson 10 – Using the COUNT function to ONLY count the TEXT in a list or cell range in Excel. Is it possible?**

**Lesson 9 – What is the INSERT FUNCTION button for in Excel? How to use it to create different FUNCTIONS?**

**Lesson 8 – What is the IF function, and how to insert it in Excel?**

**Lesson 7 – What is the ROUND function, and how to insert it in Excel?**

**Lesson 6 – What is the COUNT & COUNTA function, and how to insert them in Excel?**

**Lesson 5 – What is the MINIMUM & MAXIMUM function, and how to insert them in Excel?**

**Lesson 4 – What is an AVERAGE function, and how to insert it in Excel?**

**Lesson 3 – Simple Subtraction Formula using Excel**

**Lesson 2 – Creating SUM Functions and Replicating Formulas in Excel**

**Lesson 1 – Simple multiplication Formula using Excel**

Hope you are enjoying your learning 🙂

Habib Ali – ICT Tutor

Hi Habib,

I continue to marvel at the many possibilities of Excel. Every time you succeed in explaining a specific function in a clear way.

I’m definitely trying this one out. Good job!

Hi Catherine,

Thank you for you feedback and that my video lessons are helpful for you.

Wishing you all the best

Habib (ICT Tutor)

My mom’s occupation reuires her to make many spreadsheets and calculate the average costs of products within their company. I notice how long and tired it makes her, but after learning this function, she’ll be able to save so much time. I’ll definitely send this article to her. Thanks for sharing!

Hey Aminah,

Fantastic! Hopefully your mum would find the Excel tutorials helpful too.

Let us know if she requires to learn anything else that I have not covered in my lessons yet. I will try to create tutorials around that.

Thanks

Habib (ICT Tutor)

Great tutorial. Very easy to follow. Many thanks for sharing your knowledge.

For many years I actually only used the basic functions in Excell, but now I have the knowledge to do more, thanks to you. This will certainly make the understanding of data easier in the future.

Kind regards

Hi Andrew,

Thank you for your feedback to let us know that these Excel lessons are highly useful for you in learning different functions.

There are many more lessons on our YouTube channel if you would like to check it out.

Habib (ICT Tutor)

Hi Habib,

Thank you for sharing. After I learned the SUMIF function, this is another advanced technique that I learned from your tutorials. This is a very useful function to calculate the average results by using many criteria. Also, you taught me 2 methods to do the same things. Thank you so much.

All the best,

Alex

Hello Alex,

Many thanks for stopping by and for leaving us your valuable feedback. It’s highly motivating for me to create more tutorials for you guys who are keen to learn about the Microsoft Excel.

Best wishes

Habib (ICT Tutor)

Thank you for this great info on lesson 61. It’s been so helpful for me!!

Thank you Alyse. 🙂

Whoo this one was complicated for me! I am going to have to rewatch a couple of times! I can’t believe all the things excel can do and you always explain everything so well!

Hi,

Thank you for your letting us know that this lesson was helpful and easy to follow for you.

We have many more lessons on our YouTube channel. So, please check it out.

All the best

Your lessons are so thorough yet simple and easy to understand. I have had trouble with excel in the past, but this post has brought me some clarity on some functions that could help me with it in the future. Keep up the awesome lessons!

Thanks Shyla for your amazing feedback. It’s always great to know how people perceive my demonstration and if it makes sense to them.

I’m thrilled to know that it does!

Habib (ICT Tutor)

Oh, I though the AVERAGEIFS function in Excel is the same as AVERAGEA. But it turns out that both are different and both need practise. I am going to post a few links of your articles to my facebook, so that my Excel-challenged friends can also read up on this. It’s a really useful function.

Thanks.

Aparna

Thank you for that. Glad you found these lessons useful.

Best wishes

Habib (ICT Tutor)

I have been using spreadsheet for many years now and just discovered that there was an easier way with less calculation to do the same thing. This is going to save me a lot of time and frustrations on trying to figure out out to find an answer in a buch of data. Thanks for clarifying this function, your lessons are short and very clear to follow.

Hi,

Thank you for stopping and for feedback. It’s humbling to know my video tutorials on Excel have been helpful for you.

I have many more lessons uploaded on my YouTube channel here, and I have more exciting content comng up soon.

Best regards

Habib (ICT tutor)

Oh, despite thinking to be familiar with Excel, I obviously do forget some things. I haven’t used this function for quite a while, and, frankly, I’m not even sure I could’ve pulled out the steps for it in a second, had I needed it.

I watched the video carefully, and thanks to you, refreshed my memory 🙂

I do like your style of explaining. Your offline student are also quite happy to have you as their tutor. Well done, Habib, again.

That’s amazing to know Kerryanne! Glad my video tutorials On Excel have been beneficial for you.

All the best

Habib (ICT Tutor)

Hey,

This lesson is very good for me as I am a project manager and part of my role is to work out the costs of the project each month. These costs include people’s hours, materials, mistakes etc. etc. The averageifs in excel can definitely help me with this.

So, I will start to use it this week and I will let you know how I get on with it.

Thank you for sharing and keep up the great work.

All the best,

Tom

Hey Tom,

This is amazing news that my Excel lesson would be helpful for you in your day to day job. Once you tried the averageifs function, please do give us your feedback here.

Many Thanks

Habib (ICT tutor)

Hi Habib,

Thank you for this tutorial. I was confused between the AVERAGEIF and AVERAGEIFS functions. Now, after watching your video, I have a better understanding of the difference and how to use them properly. The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria. Got it! I also appreciate the two methods you shared. It’s so handy!Thank you so much! 🙂

Great feedback and learning. Well done Ferra! 🙂

Reading such comments really wants me to constantly improve on my content and provide you with the best.

Best wishes

Habib (ICT Tutor)

Hi Habib,

Another classic lesson on about how to use the AVERAGEIFS function to work out the average results by using criteria’s from multiple columns. Your lessons are always clear and very straight forward.

I just can’t imagine you are giving out all these lessons for free. This is very kind of you.

I Just want to say thank you for the time you taking out to make these tutorials available for free here.

I really appreciate and I will be sharing with friends as well.

Thank you for your kind comments Albright.

I decided not to charge for my lessons as I believe in free education, especially for those who cannot afford the huge fees courses have. Normally I would charge premium prices for my courses, but here on my website and my YouTube channel they are free for anyone to learn from, and share with their loved ones, all over the world. take care 🙂

Habib (ICT tutor)

I think it’s a great idea you’ve included an option to download this lesson on computer together with YouTube video. Thanks for sharing this lesson on AVERAGEIFS function in Excel. I’m complete newbie at this so your video lessons help a lot. Keep up the good work!

Hi Ivan,

You are welcome! Hopefully you will be able to learn about Excel through my video lessons. You can also visit our YouTube channel for more content like these. I’ve also got many more videos coming up on Microsoft Office.

All the best

Habib (ICT Tutor)

This is another great lesson to this collection, not long ago I enrolled on a paid course to learn excel. I don’t want to mention the site, but it was a very well known one, and to be honest, the quality of your excel lessons is much superior. I am a fan of this site, and this lesson on AVERAGEIFS is of great use for data sheets involving lots of data points.

Thank you for sharing, always back to consult here!

Very happy to hear you think my lessons are superior compared to this paid course. I will always have all my courses I publish here and on my YouTube channel for FREE. Many thanks for your feedback Pablo.

Habib (ICT tutor)

Coming from a freelance career as a software developer I remember way back when Excel was in its infancy days where to do a simple task meant writing some visual basic.

In those days it was difficult if you wanted a professional looking spreadsheet, so to see where Excel has come is quite impressive.

Nowadays I only use Excel in a simplistic way but even that would be classed as complex way back then.

I am however following your series, so thanks for sharing

Yes Mick, I agree all software’s have come a long way. Happy to hear you are enjoying the excel series of lessons. Thanks and take care 🙂

Habib (ICT tutor)

Hi Habib. Thank you for the lesson! With the help of AVERAGEIFS function make work so much easiler especially when we have a huge data. Looking forward to learn more function 🙂

Hi Janet,

Many thanks for your compliment and feedback. It’s highly appreciated. Glad to hear my lessons are making your work much easier when dealing with large data. I am in the procress of creating more video tutorials on my YouTube channel here

Best Regards

Habib (ICT Tutor)

Thanks again Habib! Your excel tutorials are a lifesaver. I have a pretty good basic understanding and even formal education in Excel but I’m completely lost with many of the advanced functions because I haven’t used Excel extensively for a decade until recently! Doesn’t help that I didn’t learn Excel in English like I’m using it now lol! 🙂

hi,

That’s great to know!

Thank you for your feedback.

All the best

Habib (ICT tutor)

I am getting there, Habib. This AVERAGEIFS is more difficult than for instance SUM (sorry, I hear you thinking, duh!) 🙂

But by following the steps and practising I will get it at some point.

Thank you so much for your explanations.

You are definitely getting there Hannie. Practice makes perfect. Keep at it and you will get these.

Thank you for your comment.

All the best

Habib (ICT Tutor)

Great tutorial Habib,

As usual you deliver the best material for those who love Excel and for those who want to learn more.

Average functions in Excel are very useful and fun, particularly SUMIFS.

Thank you very much!

Thanks Pablo,

I try my best to teach with quality and as easy to follow as possible lessons.

Hope you are learning a thing or two from my video tutorials from Excel.

Best wishes

Habib (ICT tutor)

Another really helpful lesson. I had no idea Excel could do all this stuff. The downloadable worksheet was a nice touch. It helps the information stick when you’re actually doing it as you’re learning. Thanks for this.

Hi Debbie.

Thank you for your feedback. I try my best to teach all aspects of Excel. Glad to know the downloadable worksheet was helpful for you.

All the best

Habib (ICT tutor)

This is also very well explained. I am going to need to practice a little more. When I tried this in the past, I had some trouble with it, but probably because I had formatted cells as text instead of formulas. After watching this tutorial, I should not have any problems anymore 🙂

Thanks for another great lesson!

That’s great to know Christine. Glad to know my video lessons on Excel are useful for you.

I have many more lessons on my YouTube channel if you would like to learn more.

All the best

Habib (ICT tutor)