How can we help you today?

Search for answers to your questions by entering keywords below, or look through our knowledge base.

Welcome to 'Sikkhon' User Forum

Thanks for visiting our Forum. It provides an opportunity for our visitors/users to interact with out team and fellow visitors/users. You can find further resources in Knowledge Base and tutorials. Please don't submit any personal or confidential info here, instead create a ticket.

Calculate the Average in MS Excel

Posted 10 months ago by Alamin Amin Hossain

Un Answered
Alamin Amin Hossain

The tutorial will teach you the most effective formulas to calculate the average numbers.  There are many different ways to calculate the average of a group of numbers.


If you want to calculate  average numbers of your sheet you need to use =AVERAGE() formula. The AVERAGE formula is a popular way to retrieve the average of a set of numerical data points.


Example Face:

   AVERAGE(number1, [number2], …)


If your cell (number1, number2,) or etc. are numeric values for which you want to get the average then follow the below steps.



Simply enter =AVERAGE(C3:C5) the formula to get  average.


If you are using an empty column/ Cells with zero values to write the AVERAGE formula which is "=AVERAGE(C2:C5)" then Excel will ignored and calculation will show automatically. But, empty cells are not working some time. 


So, Please try to ignore empty cells in  AVERAGE formula.


That's how you use the AVERAGE function in Excel to find  AVERAGE. 


Still If you are facing any issue please reply this post. 


#sikkhon #msexcel






0 Votes


0 Comments

Login or Sign up to post a comment