You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

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

Top-ranking reply

Wayne Contello

Level 7

26,577 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