How to calculate SUM in Excel on Mac with Examples

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.

Excel Formula Bar as seen on Mac

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

SUM as show on Excel Status bar after Column Selection

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

Calculate SUM using Formula in Excel on Mac

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.


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


3. Using the Formula Bar

    Like example 1, we type the formula on the formula bar instead of the cell.


Note: All examples are based on Microsoft Excel for Mac running on macOS

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!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap