When are they used:
AVERAGE :- You use the AVERAGE function in Excel to return the average (arithmetic mean) of the specified cells.
Example 1. Calculating an average of numbers To find out an average of certain numbers, you can supply them directly in your Excel average formula.
For example, =AVERAGE(1,3,4) returns 2.67 as the result.
AVERAGEIF :- The classical use of the AVERAGEIF function in Excel is finding an average of cells that exactly match a given criterion.
=AVERAGEIF($F$23:$F$33,"Banana",$G$23:$G$33)
Instead of entering the condition directly in a formula, you can type it in a separate cell and refer to that cell in your formula:
=AVERAGEIF($F$23:$F$33,H27,$G$23:$G$33)
AVERAGEIFS :- The AVERAGEIFS function in Excel is a plural counterpart of AVERAGEIF. It allows for multiple conditions and returns the average (arithmetic mean) of cells that meet all of the specified criteria.
AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
=AVERAGEIFS($S$23:$S$33,$R$23:$R$33,T23,$P$23:$P$33,T25)
