How To Calculate Average Manually in Excel
To calculate the average without using the AVERAGE function, we can sum all numeric values and divide by the count of numeric values. We can use SUM and COUNT functions like this:
= SUM(A1:A5)/COUNT(A1:A5) // manual average calculation
Here:
- SUM function is used to add multiple numeric values within different cells and
- COUNT function to count the total number of cells containing only numbers.
Let us look at an example :
Here we are calculating the average age of all the customers from Row 2 to Row 12 using the formula :
SUM(B2:B6)/COUNT(B2:B12)
How To Calculate Average in Excel? ( Formula & Examples)
Whether you’re a student crunching numbers for a project, a business analyst examining sales data, or simply someone looking to get insights from personal data, mastering the art of calculating averages in Excel can significantly enhance your data-handling capabilities.
In this article, we’ll look at the basic average functions in Excel along with examples and even touch on some tricks for handling more specific needs.