Skip to main content

How to add in Apple Numbers

how to add in apple numbers macbook desk
Image used with permission by copyright holder

Apple Numbers is a handy spreadsheet application that comes with macOS, iOS, and iPadOS. Numbers works like Microsoft Excel and Google Sheets, so you can track sales, inventory, budgets, stocks, and similar numeric data.

To analyze the data you enter, you likely have numbers that you want to total. We’ll show you how to add in Apple Numbers a few different ways on Mac, iPhone, and iPad. This lets you pick the method that works best for you on the device you’re using.

Difficulty

Easy

Duration

5 minutes

What You Need

  • Mac, iPhone, or iPad

  • Apple Numbers

Add using Insert in Numbers on Mac

One of the quickest ways to add in Numbers on Mac is by using the Insert menu. You can access this in the menu bar or if you have the button in your Numbers toolbar.

Step 1: Numbers is smart enough to know which numbers you want to add if they’re in a column or a row. So, you don’t have to select the cells first unless you prefer to do so.

If you do select the cells you want to add, skip the next step.

Step 2: Choose the cell where you want to place the sum.

Step 3: Either select Insert > Formula from the menu bar or the Insert button in the toolbar. Then, choose Sum.

Sum in the Numbers Insert menu.
Image used with permission by copyright holder

Step 4: You’ll see the values in your cells added up in your selected cell.

If you choose the cell, you’ll see the formula for the Sum function in the Formula Bar at the bottom. You can edit the formula here as needed.

Numbers added in a spreadsheet.
Image used with permission by copyright holder

Enter the Sum function on Mac

If you prefer to write a formula yourself, you can enter it with the Sum function for the cells you want to add instead.

Step 1: Select the cell where you want to place the sum.

Step 2: Type the equal sign (=) and you’ll see the formula box appear.

Formula box in Numbers on Mac.
Image used with permission by copyright holder

Step 3: Enter “Sum” into the box and then pick it from the options that display.

Sum in the Numbers formula box.
Image used with permission by copyright holder

Step 4: You can either type the cell range you want to add or select Value in the formula and then drag through the cells.

Selected cells added to the formula.
Image used with permission by copyright holder

Step 5: Use the Check mark in green to enter the formula into the cell.

Like the Insert option, you’ll see the total for your values in your chosen cell and the formula in the box at the bottom.

Numbers added using a formula.
Image used with permission by copyright holder

Use a quick formula in Numbers on iPhone and iPad

Similar to the Insert menu in Numbers on Mac, you have a quick way to add numbers on iPhone and iPad.

Step 1: Select the cell where you want to place the sum.

Step 2: Tap the Cell button on the lower right.

Step 3: Scroll down inside the pop-up box and choose Sum at the bottom, below Quick Formulas.

Step 4: You’ll see your total added in your selected cell.

Enter the Sum function on iPhone and iPad

If you’d like to enter the formula for the Sum function manually, this is another option on iPhone and iPad.

Step 1: Choose the cell where you want to place the sum.

Step 2: Tap the Cell button on the lower right.

Step 3: Pick New formula in the pop-up box that appears.

Step 4: Type “sum” into the box and then choose it from the list of options.

Step 5: Select Value in the formula. Then, enter the cell range or select it on the sheet to place it in the formula.

Step 6: Use the Check mark in green to enter the formula into the cell.

Step 7: You’ll then see your cells added in your selected cell.

Now that you know how to add in Apple Numbers, why not learn more about Excel too? Take a look at how to multiply or how to subtract in Excel.

Sandy Writtenhouse
Sandy has been writing about technology since 2012. Her work has appeared on How-To Geek, Lifewire, MakeUseOf, iDownloadBlog…
How to delete Slack messages on desktop and mobile
how to delete slack messages message confirm mac desktop

If your company uses Slack as its preferred communication tool, then you'll need to know the basics of navigating it. And one action you might want to know how to take in Slack is deleting a message. You can remove a direct message or one you post in a channel using any of the Slack desktop, web, and mobile applications.

For those times when you type a message in the wrong channel or conversation or simply say something you wish you hadn’t, here’s how to delete Slack messages.

Read more
The Vision Pro is already in trouble. Here’s how Apple can turn the tide
A man wears an Apple Vision Pro headset.

Apple’s Vision Pro headset lit the world on fire when it was announced at the Worldwide Developers Conference (WWDC) in June 2023, and again when it launched in February of this year. But in the months since, it’s apparently been losing steam, with sales down and people staying away from in-store demonstrations. That doesn’t bode well for Apple’s “next big thing.”

The key question, though, is whether this an actual problem for Apple. And if so, what can the company do about it?
In free fall?
If you read Bloomberg journalist Mark Gurman’s latest Power On newsletter, you’ll see some concerning reporting, at least from Apple’s perspective. Citing staff at Apple’s retail stores, Gurman claims that “Demand for [Vision Pro] demos is way down. People who do book appointments often don’t show up.”

Read more
Best Samsung Prime Day deals: TVs, phones, monitors and more
Samsung Galaxy Z Fold 5 on a flat surface with the purple Galaxy Buds 2 Pro TWS Bluetooth earbuds on the side.

Samsung is one of the hottest brands in this year's Prime Day deals, as you'll be able to take advantage of discounts on all kinds of electronic devices such as TVs, smartphones, and appliances. Whether you're thinking about buying directly from Samsung or from any of the popular retailers, you can be sure that there's something from these offers that will catch your eye. You're going to have to hurry with your purchase though, as Samsung Prime Day deals are expected to sell out quickly. Check out our favorite bargains below, but act fast if you don't want to miss the savings.
Samsung TV Prime Day deals

Samsung is one of the best TV brands, so there will surely be high demand from shoppers for Samsung Prime Day TV deals. However, while Samsung is known for its top-of-the-line TVs with all of the latest technologies, it also offers budget-friendly TVs that are going to be even more affordable during the shopping holiday. Stocks are expected to run out fast though, so if you see a Samsung TV that you want to buy for Prime Day, it's highly recommended that you push through with the transaction as soon as possible.

Read more