MacMost Q&A Forum • View All Forum QuestionsAsk a Question

How Do I Get a Running Total In a Summary Sheet From Multiple Sheets In Numbers?

I have a running total cell ie. cell T3 in my summary sheet. I want that cell to capture the value from a total’s cell “T6″ on a different sheets, each sheet is a copy from a master. Cell T3 on the summary can say”=SUM Sheet1,T6” for example. But when i create a new “Sheet2” then “Sheet3” and so on, how can cell T3 on the summary sheet automatically adjust to include cell T6 from each new Sheet and continue to give me a running total?
Thanks.

Mac Numbers version 6.0 on Mojave.
—–
Terry Upshall

Comments: One Response to “How Do I Get a Running Total In a Summary Sheet From Multiple Sheets In Numbers?”

    3 months ago

    I can’t think of any way to do it other than to manually add the new cell each time. The idea behind doing database-like things in Numbers is to put “records” into rows. But it sounds like each sheet is a record here. Is there any way to have all the data for each record in a row instead? If the data is in cells A1 to T6 in each sheet, can it not be in one row instead of 6? And if so, can you not add it to a single table for all the records? That is how spreadsheets are supposed to work.

    Hard to say more without seeing what you are doing.

Comments Closed.