How to Calculate the Sum of Numbers Without using Formula in Excel!!
Tags: excelpreface, excelbasics, exceltutorials, sumwithoutformula
Published: 2021-01-12 03:46:53

---
title: How to Calculate the Sum of Numbers Without using Formula in Excel!!
published: true
date: 2020-12-25 12:47:29 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,sumwithoutformula
canonical_url: https://geekexcel.com/calculate-sum-without-formula/
---

Generally, we can use the[formula to sum the values in Excel](https://geekexcel.com/excel-formulas-to-sum-or-subtotal-the-entire-columns/). In case, you need to **sum the numbers without using any formula** means, what would you do? Let’s get into this article!! Here, we will introduce several tricks to solve them in Excel easily. Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## SUM – Definition:

A [sum](https://geekexcel.com/sum-function/) is the addition of two or more numbers. For Example, the sum of (1,2,3, and 4) is equal to 10.

## Steps to sum the values in Excel:

There are more ways available to calculate the sum in Excel. The following steps help to show how to calculate the sum of numbers without using any formula in Excel.

- First, we need to give the input data in a worksheet and select the range.

![Select range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/select-range-1.png)<figcaption id="caption-attachment-20333">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.
- Here, you need to select the **“[Sum](https://geekexcel.com/sum-function/)“** from the list.

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

- It will calculate the sum of the given data and return it to the bottom of the selected column.

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

## Conclusion:

From this tutorial, you can get some clarification on how to find the sum of the numbers without using any formula in Excel. Hope you like this article. If you have any **questions,** feel free to **comment**. Thank you !!

### Read Also:

- **[Excel Formulas to Calculate the Average of Numbers!!](https://geekexcel.com/excel-formulas-to-calculate-the-average-of-numbers/)**
- **[Find the Average of Numbers Without Using Formula in Excel!!](https://geekexcel.com/find-average-excel-without-using-formula/)**
- **[Apply Mathematical Operations Without Using Formula in Excel 365!!](https://geekexcel.com/apply-mathematical-operations-without-using-formula-in-excel-365/)**
- **[How to Round Cell Values without Formulas in Excel Office 365?](https://geekexcel.com/how-to-round-cell-values-without-formulas-in-excel-office-365/)**