Skip to main content

How to add in Apple Numbers

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.

Related Videos




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.

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.

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.

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

Sum in the Numbers formula box.

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.

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.

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.

Editors' Recommendations

9 Apple products we’re expecting in 2023: iPhone 15, M2 Mac Pro, and more
An iPhone 14 sitting on a wood desk.

Apple is one of the most secretive companies in the world of big tech. Rumors of future products seem to develop years ahead of their time, and while we can all speculate as much as we want, we don’t really know what new products Apple has coming until they're announced. For existing products, though, it’s a little easier since most of those tend to be on an annual upgrade cycle, with a few exceptions.

But the rumor mill for new products, like Apple’s mixed reality headset, has been reaching peak levels of hype recently, which leads us to believe its release is imminent. We could also have the first iPhone with USB-C charging, eliminating the need for proprietary Lightning cables, and even a 15-inch MacBook Air.

Read more
The Framework Laptop 16 is officially my most anticipated laptop
framework laptop 16 most anticipated 01

Framework has announced a new addition to its lineup of modular, repairable laptops -- the Framework Laptop 16. It's far from just a larger version of the Framework Laptop 13, though. It takes the idea of modularity to the next level, adding a number of new expansion systems that can be customized to your heart's content -- especially for those who need more powerful graphics.

Before we get to those neat expansion systems, though, just take a look at this design. The two-tone design takes the best of an Alienware gaming laptop and a MacBook Pro, while still feeling totally fresh. I dig it.

Read more
Why you should buy the LG gram Style while this deal is happening
LG Gram Style top down view showing display and keyboard deck.

This content was produced in partnership with LG.
Who wants a dull looking laptop, right? These days, pretty much everyone owns a laptop so it's good to stand out from the crowd when many look pretty dull or overly practical. While the general consensus is that Apple rules the roost when it comes to good-looking laptops, we've spotted something that may buck that trend. It's the LG gram Style and it lives up to its name perfectly. It looks incredibly good while also being powerful to use and having a sweet-looking screen. Even better, it's available at the moment with twice as much RAM for the same price so we're talking fantastic futureproofing for all your needs. The offer is valid from now until April 16 so you've got a bit of time to commit to it. The 16-inch model with 32GB of memory is normally priced at $2,000 but there's a $200 discount so it's that bit more affordable at $1,800. In addition to the 16-inch model, there's a 14-inch 32GB model that is $300 less, down to $1,500 for a limited time. We kinda want it for ourselves so instead, we thought we'd tell you why you might want it.

Seriously though, how good does the LG gram Style look? It looks like the kind of thing you want to instantly buy even if you really don't need a new laptop right now. It's available in either 14-inch or 16-inch models. Predictably, that means the smaller model is more portable but the 16-inch model feels like it's rivalling the MacBook Pro when it comes to both looks and prowess. We're stuck wondering how come LG isn't considered one of the best laptop brands yet that feels like it's going to change if it keeps up this kind of reputation. It's about time we saw a seriously gorgeous-looking Windows-based laptop.

Read more