Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Level 1

4 points

Total a cell across multiple sheets in Numbers

I have a spreadsheet with about 60 sheets. I need to create a summary sheet with totals from all the sheets. Is there a way to enter a range of sheets with the SUM function, or do I have to select each cell in each sheet?

Mac Pro, iOS 10, Numbers 4.3.1

Posted on Mar 13, 2018 5:54 PM

Similar questions

sum of cells from different sheets how can I insert a sum of cells from different sheets? I use numbers as a warehouse control and I have different sheets depending on the brands. I would like to automatically add some cells to each sheet
234 1
how to add a function that sums the same cell in all sheets automatically Hi everybody, I need to create invoices with this software. Each invoice is a new sheet. I would like to have the possibility to automatically sum values written in the same cell of each sheet I create. How can I do? thanks
284 6
Add total across sheets Hi I have an invoice set up in numbers. I want to add the total of each sheet (in cell F40) into a final sheet at the end with a grand total. However, as the year goes on I need to add sheets so I cannot have a set amount of sheets at the start. In Excel I had the formula =SUM(start:end!f40) on the total page, so I had a blank sheet titled start, and a blank sheet titled end at either end of the invoice sheets. Therefore, in Excel as long as I added a new invoice between the blank start and end ones, the total page would include it. I cannot for the life of me work out how to set up similar in numbers. The nearest I can get is to add a new sheet manually to the total page formula every time I add an extra sheet to the workbook. Any ideas? Thanks
339 7

There are no replies.

Total a cell across multiple sheets in Numbers

Welcome to Apple Support Community

A forum where Apple customers help each other with their products. Get started with your Apple ID.

Learn more Sign up