Numbers: SUMIFS formula with TODAY() for dates

Question

Level 2

398 points

I'm having a problem comparing dates to Today's Date function in an SUMIFS formula in Numbers for Mac.

Here's my broken formula: =SUMIFS(C2:C9),B2:B9,"<="TODAY)

Column B contains Payment Dates

Column C contains Payment Amount

What is wrong with my formula?

Google AI pointed out my syntax errors and showed me the correct formula:

SUMIFS(C2:C9,B2:B9,"<="&TODAY)

I hope this correction helps anyone struggling with comparing dates to TODAY().

John

Mac mini, macOS 26.5

Posted on May 26, 2026 11:08 PM

Reply

Answer 1

Level 2

398 points

SUMIFS() is intended when testing multiple criteria, so it was overkill in my example.

SUMIF() is what I should have used since I only had one test criteria.

SUMIF(test-values, test-criteria, values to be summed)

SUMIF(B2:B9, "<="&TODAY, C2:C9)

Granted it looks very similar to my SUMIFS formula.

I think of SUMIFS as plural, reminding me I only need to use it for multiple criteria, otherwise use SUMIF.

John

Reply