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

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

  1. Understand, what the AVERAGEIF function is used for
  2. Insert an AVERAGEIF function

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 anything 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 61 – AVERAGEIFS function in Excel | Find the average value by using many criterias in excel

Or go back to:

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

23 thoughts on “Lesson 60 – What is the AVERAGEIF function in Excel | How to insert the AVERAGEIF function in Excel?”

  1. Wow great lesson! Lesson 60 what is the averageif function in excel has been such a helpful lesson. Thank you so much!! Best wishes!

  2. The AVERAGEIF function is another cool feature in Excel that I quite enjoyed learning about by watching this lesson. I really appreciate the details that you go into in your lessons when you are teaching something – that helps so much.

    Thank you for another great lesson!

    • Hi Michael,

      Thank you for the comment and feedback. I try my best to offer all the learner the best learning experience of Microsoft Excel. Glad I have been successful in your case.

      Best wishes


  3. This is exactly where I was stuck on my spreadsheet. I am working on making a couple of different budget budget spreadsheets. I wanted to be able to see certain things over time like my groceries budget and average spent each month. Now I can get back to work on it. Thank you

    • This is an amazing news that I have been able to help you budget your groceries on what was spent on average each moth. Glad I have been of some help to you.

      Best regards

      Habib (ICT tutor)

  4. Well done on getting to post 60 lessons on Excel, very impressive! These are so straight-forward and very easy to navigate, which is important.

    I also like that your videos are to the point and you don’t tell us your life story like many videos tend to do these days.

    • Hi Sharon,

      Thanks for your feedback. I’m glad to hear my lessons are good quality and easier to follow.
      Best wishes

      Habib (ICT Tutor)

  5. I’m learning so much from your videos and articles,
    Please keep them coming; I think that by the end of the year, I’ll be an expert with excel!

  6. Woohoo! I’m already on lesson 60! I have learned so much! You are an excellent tutor and you made these lessons very clear and easy to follow. This is another important and useful function in Excel.
    Thank you for another great lesson!

    • Hey Christine,

      Thank you for your lovely feedback. It’s great to know that my video tutorials on Excels are helping you learn about Microsoft Excel.

      Best Wishes
      Habib (ICT Tutor)

  7. Hi,I love the short and clear explanantion of the AVERAGEIF function, and what the function is. Very good to highlight the absolute format and its importance in order to use the AVERAGEIF function.

    I like the fact that you are using videoexplanantion in your tutorials. It makes it easier to follow your explanations.


    • Thanks for your comment Roy. The absolute cell refence is the key, if you want to reduce time by replicating the function into other cells, so you don’t have to do each function separately. Take care 🙂

      Habib (ICT tutor)

  8. Another great lesson from you!
    As I already said, I feel “at home” in Excel, but this one particularly I almost forgot exists. I haven’t used it probably for ages and if I am honest, not quite sure I’d do it correctly if I needed it at some point. It is so good that you reminded me how to do it. I think I could actually include this function more often.
    Thank you very much!

    • You’re very welcome Kerryanne. Thanks for your comment and I’m always happy to be reminding you of functions you may have used in the past. Take care 🙂

      Habib (ICT tutor)

  9. Hi there,
    Thank you for the amazing tutorial.
    I have no idea about AVERAGEIF but you have just explain and everything to me in just a short video.

    I must say I really appreciate your teaching.

    Thank you.

  10. Dear Habib, thank you for another great explanation of the Excel Averageif function that calculates the average of numbers. With every new lesson I build up my knowledge in Excel. Can’t wish better tutorials.

  11. Hi Habib,

    I have to honestly say that this is most in-depth and informative tutorial I’ve ever seen on the AVERAGEIF function in Excel.

    I recall a few years ago I had to do this for mortgage sales (back in my banking days) within certain thresholds, below certain thresholds, and above certain thresholds.

    Oh my, how I could have done with this tutorial back then, LOL.

    I remember searching online for information about how to do this quickly and easily in Excel, but to be honest much of the information didn’t make a great deal of sense.

    Believe it or not, in the end I had go through our region’s (London) 2,000+ quarterly mortgage sales manually and calculate the average sales. I love my numbers and am happiest when dealing with figures, but this was pretty soul-destroying.

    I have to say that ALL of your tutorials that I have come across are just so easy to follow and make a great deal of sense. Love it. Keep up the great work.


    • Thank you for your lovely feedback and sharing your story. All my lessons and tutorials will always be simple and straight to the point and easy to understand. Take care 🙂

      Habib (ICT tutor)


Leave a comment

Share via
Copy link
Powered by Social Snap