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
Question marked as Top-ranking reply

Posted on May 28, 2025 10:20 AM

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)


More on the functions here:


SUMIF - Apple Support


SUMIFS - Apple Support


SG



1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.