Performing calculations, such as adding up a list of numbers, is one of the most common tasks in Microsoft Excel. Luckily, Excel provides many built-in functions to help you perform calculations quickly and easily. One of the most useful functions for adding up numbers is called SUM.
When you open an Excel sheet or create a new one on your Mac, you will notice a bar just below the ribbon labeled as fx this is called the "Formula Bar". This bar displays the formula or function that is currently being used in the selected cell. You can also use the Formula Bar to enter or edit formulas and functions in Excel.

To learn how to calculate SUM, let us add some data to work with in Sheet1.
Example Data:Region | 2020 Earnings (in $) | 2021 Earnings (in $) | 2022 Earnings (in $) |
---|---|---|---|
Region | 12000 | 15000 | 11000 |
Region | 110000 | 159800 | 97000 |
Region | 12000 | 17000 | 80000 |
Region | 2110000 | 3020000 | 2020000 |
1. Display SUM on the Status bar by selecting Column

As you can see in the above gif example, as you select Columns B, C, or D, the SUM is calculated and displayed on the bottom Status Bar in Excel. This is really useful when you just want to see how the numbers add up in different cells on the fly.
Calculate SUM using SUM Formula

As you would see in the above gif example, we have made use of the SUM formula in 3 ways.
1. By using the SUM function on the Cell
Move your pointer to the cell where you want to calculate the SUM, now type equal-to followed by SUM and open bracket, and select all the cells from column B to calculate.
=SUM(B2:B5)
2. By Click on the fx bar
When you click on fx you will see that a Formula Builder sidebar appears where you can click on SUM after making sure your position on the sheet is where you want to display the sum
=SUM(C2:C5)
3. Using the Formula Bar
Like example 1, we type the formula on the formula bar instead of the cell.
=SUM(D2:D5)
Note: All examples are based on Microsoft Excel for Mac running on macOS
Specifications:
Excel Version: Version 16.70 (23021201)
Operating System: macOS Ventura 13
Chip: Apple Silicon M2
Device: Macbook Pro
Facing issues? Have Questions? Post them here! I am happy to answer!
- Lost your iPhone? Regenerate QR Code for Microsoft Authenticator App
- What is Microsoft 365 Message You are using more licenses on your trial than what you will purchase once the free trial ends.
- Power BI error Something went wrong, unable to read the application metadata
- How to save a file as csv in Windows Notepad?
- You're not on Teams yet, but you can set it up for your organization. [Microsoft Teams Login Error]
- Fix- Microsoft Word Pages Appear Black
- How To Remove Only Conditional Formatting in Excel
- How to record PowerPoint slide show presentation on Mac - narration, slide timings, ink gestures
- Fix 0x80070194 Error When Opening Microsoft OneDrive File
- 0xCAA20003: You ran into an authorization problem. [Microsoft]
- PowerShell git: The term git is not recognized as the name of a cmdlet
- Remove mailto link from Microsoft 365 Word Document Email Text
- How to take a screenshot on Microsoft Windows OS on PC or Laptop
- How to Force Quit Microsoft Excel Application on Mac
- [fix] Microsoft Error Code 0x80004005 - Unspecified error
- How to Delete a Sheet in Excel on Mac
- How to add Business Users using Microsoft 365 Admin Center
- [Microsoft Teams 4c7] Modern authentication failed here, but you'll still be able to sign in. Your status code is 4c7 error
- Fix Microsoft Store Error Code: 0x80072EFD
- How to add Data Analysis Add-in in Excel on Mac
- How to Select Two Separate Columns in Excel on Mac
- Internet Explorer browser auto redirect to Microsoft Edge for compatibility with modern web sites
- How to Create Absolute References in Microsoft Excel for Mac
- What is FCM Messages Test Notification! [Microsoft Teams] [Google Hangouts]
- How to Sync Microsoft Teams Calendar with Mac Calendar
- Jupyter: Safari Cant Connect to the Server localhost:8888/tree - Python
- What version of windows do I have? - Microsoft
- Simple Crossword Puzzle example using Pure HTML, CSS and JavaScript - Html
- How to install AWS Toolkit for Visual Studio Code - AWS
- Emulator: Warning: restoring GLES1 context from snapshot. App may need reloading. - Android-Studio
- How to comment code in Python - Python
- Where are Notepad++ macros stored? - NotepadPlusPlus
- How to display Line Number in Eclipse IDE - Eclipse