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.

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

Tags:

english-heritage listed on couponmatrix.uki-saw-it-first listed on couponmatrix.ukmedicspot listed on couponmatrix.uksimplycook listed on couponmatrix.ukwaitrose-pet listed on couponmatrix.ukwood-finishes-direct listed on couponmatrix.uk
english-heritage listed on couponmatrix.ukEngland is home to some spectacular heritage. From Stonehenge to Hadrian's Wall, Dover Castle to palaces and statues, English Heritage allows you to visit this remarkable country through the ages. With 66 castles, 84 ecclesiastical sites, 23 historic gardens, 27 forts and defences, 6 historical bridges and much much more, use your English Heritage discount code to discover something remarkable near you without breaking the bank. Love England with English Heritage.
i-saw-it-first listed on couponmatrix.ukCalling all fashionistas. I Saw It First provide daily updated clothing inspired from the hottest trends and designers to keep you looking fresh and always on point. Whether you want a sizzling dress, cute swimwear, comfy nightwear or pretty much anything fashion, you’ll find a gorgeous selection of brand new never before seen items on I Saw It First. With I Saw It First discount codes you can enjoy looking and feeling great for less. Just as every girl is unique, every item of clothing deserves to be unique too.
medicspot listed on couponmatrix.ukCOVID tests for travel are now a must for any overseas trip, so it’s a good thing that Medicspot and its quality testing services are always just a few clicks away. Regardless of if you need same day results for your travel plans or the opportunity to cut your quarantine short, use a Medicspot discount code to knock the cost of the tests you need before you buy. Who knows what tomorrow brings, so let Medicspot be there to protect you for any scenario life throws at you.
simplycook listed on couponmatrix.ukAt Simply Cook or mission is to get Britain cooking! Despite our nation’s love of food, recipe programmes aplenty and celebrity chefs on every channel, did you know that most of us only have six meals or less in our repertoire. Simply Cook aim to change this by making cooking a simple, hassle free process giving you and your family the inspiration, skills and experience to expand your repertoire with ease. So why not expand your tastebuds with a simply cook voucher and get cooking today!
waitrose-pet listed on couponmatrix.ukGive your furry or feathered friend a taste of the high life and pick up all your pet-related essentials from trusted brand Waitrose Pet. A Waitrose Pet promo code from us will make purchasing high quality pet supplies a breeze, so whether you need nutritious food for Fido, a scratching post for the cat or even supplements for your horse, you won’t have to break the bank. Featuring professional pet advice on tap and the very best brands in the business, place your pet pal’s needs in the capable hands of Waitrose if you believe they deserve the best.
wood-finishes-direct listed on couponmatrix.ukWood Finishes Direct is the UK's leading supplier of wood finishing products, stocking a wide range of stains, paints, varnishes, oils and waxes from all the major brands. A Wood Finishes Direct discount code makes it easy and affordable to get the perfect finish for your woodworking project - whether you're a DIYer or a professional craftsman. So don't put your latest project on hold, get a quality finish from Wood Finishes Direct and make the most of your latest creation. An easy way to get ahead of fellow woodworkers is by becoming a Wood Finishes Direct VIP. As simple as signing up to the company mailing list, VIP status ensures the owner is always the first to hear about the newest wood finishing products, allowing them first dibs on the latest woodworking solutions. Add in the fact that VIPs are privy to exclusive offers you can’t find anywhere else and you’ve got a must-have for any woodworking enthusiast. One of the best products from Wood Finishes Direct is their water-based varnish. This varnish is perfect for DIY projects and provides a high-quality, durable finish. It's also easy to apply, and cleanup is a breeze. Plus, you can save even more money on this product by using Wood Finishes Direct voucher codes. So if you're looking for a top-quality varnish, be sure to check out this product from Wood Finishes Direct.