/How to find Average in Microsoft Excel

How to find Average in Microsoft Excel


What is an Average generally…

SUM function is been used to do simple addition in Excel. In my previous article , I have looked at SUM Function in Microsoft Excel. If you missed that article, you can click on the link in order to do so.


Therefore in this article, I want to talk on how you can create or calculate AVERAGE function in microsoft excel.

Average function

I will be using this screaenshot above to show you how Average function can be used.


Now Let us find the Average

As you all know, all Excel function starts with “equals to “. You will now choose the place where the answer will appear. “= Average”. This will show you all the functions that has Average in it.

As I said in the last article,  one way of knowing if you have picked a function is that you will see a guide under it that tells you what to do next. The next thing is to highlight the numbers that you will want to see the Average of.

The next thing is to Press ENTER and the answer will appear.

Another tip about Average

  • You need to perform auto fill to get the remaining answers instead of doing it one after the other which is time consuming.
  • You will click on the first answer and come to the edge until your cursor changed to a tiny plus symbol.
  • You now hold your mouse and drag down or when you see the small plus, you double click and all the answers will appear now.



There is another way that you can calculate AVERAGE for Microsoft Excel. You can make use of the Function Library just like I did for the SUM function. I still want to say that it is absurd for you to use Function library for that simple calculation.


Action Point

If you enjoy our article, sign up to get our next article in your inbox. You need to confirm your subscription by clicking on the link sent to your email. You can check the spam folder for it.


Add us to your mailing list to receive directly from us. Thanks.




Salau Adeniyi Olayinka (CEP, MCTP,CSCU, Hubspot Inbound Marketing Expert) is an accomplished Digital Marketer and E-Business Consultant . His passion is writing and sharing of knowledge and meeting people. He intends to use this blog to boost ICT and E-Business Knowledge in Nigeria and beyond.