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)

Admin

Hi, I am Imran Alam, Full Stack Developer. Helping local businesses to enhance their reach to customers through Websites, Web / Mobile Application, and Digital Marketing. We offer a long range of services like Website Designing, Android Application, School Management System, LMS Software, Point of Sale (Pos) , SEO, Social media Marketing, and Technical Support as well.

Leave a Reply

Your email address will not be published. Required fields are marked *

Share via
Copy link
Powered by Social Snap