sum from multi sheet and catageories in summary sheet

Question

Level 1

14 points

sum from multi sheet and catageories in summary sheet

I have created a checkbook register using the Apple spreadsheet template and modified according to my needs

I have created 8 additional identical sheets each is for my each individual account and given the name for that sheet

Then I have created a summary sheet, which has got start date and end date and category list. Then I have used Sumifs formula to get the data from the individual 8 sheets into summary sheet. The formula is a little bit long because each name has to be written for every sheet and I was wondering whether there is some other way to create a table with account name and use this table. I am attaching a screenshot for better understanding.

Excel and Google sheet has a formula using summif with array, which I tried but Apple numbers not accepting.

Any suggestion or better way to write formula.

is it possible to write one cell formula which will spill in rest of cells. Apple has many new functions but there is not lot of information available how to use it.

Thanks

Ashok

[Edited by Moderator]

iMac 24″, macOS 15.5

Posted on Jul 30, 2025 2:22 PM

Reply

Answer 1

Badunit

Level 7

30,336 points

Jul 30, 2025 4:54 PM in response to arp1007

Go toi Numbers->Settings and uncheck "use header names as labels". This will shorten your cell references and make your formulas shorter and easier to read.

If all of your references are ranges/arrays, SUMIFS will spill down. Like in this formula:

=SUMIFS(Sheet 1::Table 1::B,Sheet 1::Table 1::A,A)

Each row will have the SUMIFS result that match the contents of column A in its row.

=SUMIFS(Sheet 1::Table 1::B,Sheet 1::Table 1::A,A&D2) also spills down because A&D2 is an array

If something in the formula prevents it from spilling down, you can always fill down manually like we've done for years.

Reply

Answer 2

arp1007 Author

Level 1

14 points

Aug 9, 2025 5:17 AM in response to Badunit

I am sorry I can not understand your first formula refers to B? there is nothing in that cell

in second formula you refer A&D2 what is that refers to.

I think I confused you in my first screen shot but here is new from actual summary sheet. I created list of accounts table, maybe this helps you for providing me the formula .

[Edited by Moderator]

Reply