MS Excel : Averageif Formula to do Conditional Average

Excelmadeeasy@ learn how to use the Averageif formula in excel to calculate averages based on a condition given by you.
Averageif formula in excel computes the average of the numbers in a range that meet the supplied criteria. If average_range is not supplied, the cells in range are averaged. If average_range is supplied, cells cells in average_range that correspond to cells in range are averaged.

To determine which cells are averaged, criteria is applied to range. Criteria can be supplied as numbers, strings, or references.

Notes:

Cells in range that contain TRUE or FALSE are ignored in Averageif formula in excel
Empty cells are ignored in range and average_range when calculating averages in Averageif formula in excel.
AVERAGEIF returns #DIV/0! if no cells in range meet criteria in Averageif formula in excel.
Average_range does not have to be the same size as range. The top left cell in average_range is used as the starting point, and cells that correspond to cells in range are averaged in Averageif formula in excel.
AVERAGEIF allows the wildcard characters question mark and asterisk in criteria. The ? matches any single character and the * matches any sequence of characters. To find a literal ? or *, use a tilde ~ before the character, i.e. ~* and ~? in Averageif formula in excel 10 Most Used Formulas MS Excel
https://www.youtube.com/watch?v=KyMj8HEBNAk

Learn Basic Excel Skills For Beginners || Part 1
https://www.youtube.com/watch?v=3kNEv3s8TuA

10 Most Used Excel Formula
https://www.youtube.com/watch?v=2t3FDi98GBk
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel
https://www.youtube.com/watch?v=vomClevScJQ

5 Excel Questions Asked in Job Interviews
https://www.youtube.com/watch?v=7Iwx4AMdij8

Create Speedometer Chart In Excel
https://www.youtube.com/watch?v=f6c93-fQlCs

Learn the Basic of Excel for Beginners || Part 2
https://www.youtube.com/watch?v=qeMSV9T1PoI

Create Pareto Chart In Excel
https://www.youtube.com/watch?v=2UdajrDMjRE

How to Create Dashboard in Excel
https://www.youtube.com/watch?v=RM8T1eYBjQY

Excel Interview Questions & Answers
https://www.youtube.com/watch?v=Zjv1If63nGU

Видео MS Excel : Averageif Formula to do Conditional Average канала My E-Lesson