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

How to SUM cell values based on specific contents in a table row?

I will explain as best as I can

I am building a home budget spreadsheet here:

https://www.icloud.com/numbers/0V76H-clxF7B33Air6IrRCNsw#how-to-applenumbers

And I would like to sum all values of the BALANCE column in BANK 1 table that contain APRIL 2020 and category GROCERIES.

The goal here is to monitor if I am under/over spending on my budget.

I shared a Numbers file above and it is editable. If possible, please duplicate the sheet with your solution. Thank you :)

Posted on May 1, 2020 7:38 AM

Best reply

Wayne Contello

Level 7

26,535 points

Posted on May 1, 2020 8:37 AM

I suggest opening the built-in template that comes with Numbers for the personal budget. To open the template, select the Numbers menu item "File > New…"

then choose the template:

View in context

How to SUM cell values based on specific contents in a table row?

Similar questions