Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»Excel Sum Not Working? Here’s How to Fix It

Excel Sum Not Working? Here’s How to Fix It

Asmi DhakalBy Asmi DhakalAugust 5, 2022
excel-sum-not-working

Excel has made performing data calculations easier than ever! However, many things could go wrong with the application’s abundant syntax. Many users have reported certain formulas, including SUM not working on MS Excel. Some have reported the value changing to 0 when running the formula or having met with an error message.

Did you just relate to the situation we just mentioned? If you unfortunately have, don’t worry; we’ll help you solve it. Keep reading this article as we list why SUM may not work and how you can fix it!

Table of Contents

  • Why is Excel Sum Not Working?
  • How to Fix the SUM Function in Excel?
    • Look for Typos
    • Change Format
    • Replace Unsupported Symbol
    • Disable Show Formulas
    • Repair the Office App (Windows)

Why is Excel Sum Not Working?

The SUM function may not work on your Excel for a list of reasons. You could’ve made a typing error while entering the formula or used an incorrect format. Before hopping on to the solutions, you must understand the problem you’re dealing with.

  • Typing Error: We almost always overlook typing errors. However, even the most minor typing error can cause the most complex functions not to work.
  • Unsupported Format: In Excel, you have the feature to change the format of the data you’ve entered. If SUM isn’t working, the data you’re trying to manipulate may be set to text. Excel won’t add data that is set to the text format.
  • Unrecognized Symbol Used: This is mostly relevant to decimal and thousands separators. By default, the period and comma symbol, respectively, are used for each divider. If you’ve used these symbols incorrectly, the SUM function won’t work.
  • Show Formulas Enabled: You could’ve accidentally enabled the Show Formulas feature. When this feature is active, Excel will display the formula used to calculate the result instead of viewing the result.
  • Manual Calculation Enabled: If Excel doesn’t automatically recalculate the data you’ve changed from the selected cells, you’ve enabled Manual calculation.
  • Corrupted Program Files: The program files of your Excel may have gone corrupt. When the files get corrupted, the application won’t be able to complete some to all of its functions.

How to Fix the SUM Function in Excel?

You can easily fix a malfunctioning function in Excel on your own. After you’ve looked through the problems, you can move on to the solutions that sound more relevant to your problem. From each of the causes mentioned above, find the solutions below.

Look for Typos

Be sure you’ve written the function correctly. Additionally, see if you’ve used the correct symbols, such as the equals sign and parentheses. To call any function, you must use the equals sign first. Similarly, the parentheses sign is necessary before specifying the range of cells you want to add up.

Change Format

You’ll need to change the format of the selected entity to preferably Number to be able to perform any calculations on it. You can change the format of data from the Home ribbon on Excel.

Follow these steps to change the format of your data to Number on Excel:

  1. Open MS Excel to open your workbook.
  2. From the Menubar, make sure you’re on Home.
  3. On the Home Ribbon, locate the Number section.
  4. Select the drop-down menu. From the list of options, select Number.ChangeFormatExcel

Replace Unsupported Symbol

MS Excel uses the “.” symbol as a decimal separator by default. Excel won’t calculate the data if you use other symbols such as a comma (,) as a decimal separator. This is also true if you’ve any symbol except the comma symbol for the thousands divider.

If you have used these symbols incorrectly, find and replace the comma (,) symbol with the period (.) symbol and vice-versa.

Here are the steps to use the Find and Replace tool on Microsoft Excel:

  1. Open your document from Excel. 
  2. From your keyboard, hit the combination Ctrl + F. 
  3. In the Find and Replace window, head on to the Replace tab.
  4. Type in ‘,’ next to Find What. To swap it with the period symbol, type ‘.’ next to Replace with.
    replace
  5. Select Replace All.

Disable Show Formulas

To view the calculation results, you must turn off the Show Formulas option. You can disable this feature from the Formulas tab on the menu bar.

Follow these steps to disable the Show formula feature on MS Excel:

  1. Launch MS Excel to open your workbook.
  2. From the menu bar, hop on to Formulas.
    formula
  3. Locate the Formula Auditing section. 
  4. If the Show Formulas option is highlighted, select it to turn it off.
    formula-auditing
  5. Enable Automatic Calculation.

If you want Excel to automatically re-calculate the data you’ve changed, you need to set the calculation option to Automatic. You can find the calculation on the Formulas tab on the menu bar.

Here are the steps you can refer to enable automatic calculation on MS Excel:

  1. Open your workbook from Microsoft Excel. 
  2. Hop on to the Formulas tab from the menu bar.
  3. Navigate to the Calculations section.
  4. Drop down the menu for Calculation Options and select Automatic.EnableAutomaticCalculation

Repair the Office App (Windows)

You may have to repair the application for Microsoft Office. When you repair an application, your system scans for corrupted files and replaces them with new ones. As you cannot repair the Excel application individually, you’ll have to repair the entire Office application.

Follow these steps to repair the office app on your device:

  1. Use the combination Windows key + I to open the Settings application on your keyboard.
  2. From the panel to your left, select Apps.
  3. Hop on to Apps & Features, then scroll to Office.
  4. Next to the Office app, select the vertical three-dot menu.
  5. Select Advanced options.OfficeAppAdvancedOptions
  6. Scroll down to the Reset section, then select the Repair button.OfficeRepairApp
fix
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
View 2 Comments

2 Comments

  1. Joe on November 5, 2022 12:50 am

    The best solution for sum issues, after plenty searching and trying on the web. Simple and straight to the point ! THX

    Reply
    • Asmi on November 6, 2022 10:13 am

      Glad it helped you, Joe!

      Reply

Leave A Reply Cancel Reply

Latest Posts
what-does-collate-mean-on-a-printer

What Does Collate Mean on a Printer?

March 31, 2023
usb-vs-pcie-wifi

USB Vs PCIe Wi-Fi—Which One is Better?

March 31, 2023
how often to replace laptop

How Often Should You Replace a Laptop

March 29, 2023
You may also like
computer suddenly slow

Why is My Computer Suddenly Slow? 11 Ways to Fix It

March 31, 2023
HTTP-Error-431

How to Fix HTTP Error 431

March 31, 2023
scheduled task reboot

How to Create a Reboot Scheduled Task in Windows

March 31, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday, editor@technewstoday.com | Tech Central Pvt. Ltd.

Type above and press Enter to search. Press Esc to cancel.