How to Find Sum of All Digits/Numbers in a Cell in Excel Office 365?
Tags: kutoolsexceltutorial, sumofalldigitsnumber, kutools
Published: 2020-10-06 08:55:07

---
title: How to Find Sum of All Digits/Numbers in a Cell in Excel Office 365?
published: true
date: 2020-10-05 12:05:37 UTC
tags: KutoolsExcelTutorial,SumofAllDigitsNumber,Kutools
canonical_url: https://geekexcel.com/how-to-find-sum-of-all-digits-numbers-in-a-cell-in-excel-office-365/
---

In this post, you will understand the steps to Find the **Sum of All Digits/Numbers in a Cell in Excel Office 365** using **Kutools. ** Let’s step into this article!! 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Sum of All Digits/Numbers in a Cell:

- The below image has shown the sample data to which we are going to find the sum value.

![Example data](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-data-3.png)<figcaption id="caption-attachment-15168">Example data</figcaption>

- First, you need to select a blank cell to display the result.
- On the **Kutools Tab, select** the **Formula Helper** option, **choose** the **Formula Helper** option from the drop-down menu.

![Select Formula Helper option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-Formula-Helper-option.png)<figcaption id="caption-attachment-14911">Select Formula Helper option</figcaption>

- It will open the **Formula Helper dialog box. **
- You need to **choose** the **Sum numbers in a cell** option under the **Choose a formula** box.
- If you want to filter the option quickly, you need to **check** the **Filter box** and **enter sum** into it.
- In the **Cell input box** , you need to **select the cell** in which you want to calculate the sum of all digits.
- Hit the **OK** button.

![Formula Helper Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formula-Helper-Dialog-Box-4.png)<figcaption id="caption-attachment-15169">Formula Helper Dialog Box</figcaption>

- Now, you can get the result in the selected cell.
- You need to drag the first cell down to fill the remaining cell and get the result as shown in the below image.

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

## Conclusion:

In this post, you can clearly understand the steps to **Sum of All Digits/Numbers in a Cell in Excel Office 365** using **Kutools.** Drop your **queries/suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### See Also:

- [How to Sum Bold Values or Numbers Only in Excel Office 365?](https://geekexcel.com/how-to-sum-bold-values-or-numbers-only-in-excel-office-365/)
- [How to Find Numbers Based on Criteria in Excel 365?](https://geekexcel.com/how-to-find-numbers-based-on-criteria-in-excel-365/)