How do I add bills from the 1st to the 15th of the month in Apple Numbers?

Question

Level 1

8 points

How do I add bills from the 1st to the 15th of the month in Apple Numbers?

I have a list of monthly bills which I would like to add up. I want to see how much money I need in my checking for the first half of the month. I have a column which contain numbers 1 thru 31 representing each day of the month. Next to the column of numbers I have the amount to pay on that day.

[Re-Titled by Moderator]

Posted on May 28, 2025 8:19 AM

Reply

Answer 1

SGIII

Level 8

36,980 points

May 28, 2025 10:20 AM in response to housewrights

You can use SUMIF or SUMIFS. Here is a simple example.

I made the last row of the table a Footer Row. In column B of that row I entered:

=SUMIF(A,"<=15",B)

How do I add bills from the 1st to the 15th of the month in Apple Numbers?

Similar questions