Find the Average of Numbers Without Using Formula in Excel!!
Tags: excel, excelpreface, averageinexcel, excelbasics
Published: 2020-12-24 03:45:44

---
title: Find the Average of Numbers Without Using Formula in Excel!!
published: true
date: 2020-12-23 12:32:34 UTC
tags: Excel,ExcelPreface,AverageinExcel,ExcelBasics
canonical_url: https://geekexcel.com/find-average-excel-without-using-formula/
---

[Average](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/) calculation is one of the most common tasks in Excel. Normally, we can use the [formula to calculate the average](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-numbers/). Have you ever tried to calculate the **average of numbers without using any formulas** in Excel? Do you think it is possible? Let’s see them below!!
## Average-Definition:

- The average of numbers is the ratio of the sum of numbers to the total number of values in the data.

!["Average](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Average-Formula-300x154.jpg)

## Steps to calculate average in Excel:

There are a number of ways available to get the average of numbers. Let’s see the below steps to calculate the average without using the formula in Excel.

- First, you need to enter the values in a range and select the range.

![Select range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-range.png)<figcaption id="caption-attachment-20291">Select range</figcaption>

- Then, click the **“[Home](https://geekexcel.com/use-shortcut-to-open-home-tab-in-excel-office-365/)“** tab from the [ribbon](https://geekexcel.com/use-and-customize-ribbon-commands-in-excel-office-365-quick-ways/).

![Home tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-home.png)<figcaption id="caption-attachment-20292">Home tab</figcaption>

- Under the Home tab, you can see the **“Editing”** section.
- Here, you need to click the **“[Auto Sum](https://geekexcel.com/shortcut-to-auto-sum-selected-cells-in-microsoft-excel-365/)“**.

![Editing section](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Editor-tab.png)<figcaption id="caption-attachment-20293">Editing section</figcaption>

- It will expand the drop-down list.
- You need to select the **“[Average](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/)“** from the list.

![Select Average](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-Average.png)<figcaption id="caption-attachment-20294">Select Average</figcaption>

- After selecting the average, it will calculate the average of the given data and return it to the bottom of the selected column.

![Average without using formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Result-11.png)<figcaption id="caption-attachment-20295">Average without using formula</figcaption>

## Wind-Up:

In this way, you can easily calculate the **average of numbers from a range in Excel without using any formula**. I hope this article is helpful to you. If you have any other **ideas** or **queries,** feel free to let me know. Thank you so much for visiting our site!!

### Read Also:

- **[Excel Formulas to Calculate the Weighted Average ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-calculate-the-weighted-average-easy-guide/)**
- **[Excel Formulas to Calculate the Average of Top N Values from a set of Data!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-top-n-values/)**
- **[Apply Mathematical Operations Without Using Formula in Excel 365!!](https://geekexcel.com/apply-mathematical-operations-without-using-formula-in-excel-365/)**
- **[Excel Formulas to Calculate the Average and Ignore Errors!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-and-ignore-errors/)**
- **[Excel 365 Ranges and its Types ~ Easy Tutorial for Newbies!!](https://geekexcel.com/excel-365-ranges-and-its-types-easy-tutorial-for-newbies/)**