How do I "Sumif" a range for values before today (Now() or Today())

assuming the dates are in column A and the amount to sum is in column B, you can do something like this:

make the first two rows header rows.

B1=SUMIF(A, "<="&TODAY(), B)

this is shorthand for... select cell B1, then type (or copy and paste from here) the formula:

=SUMIF(A, "<="&TODAY(), B)

Hi B'

You were almost there, but missed this important detail (which is not explicitly stated—making it an easy miss) in the examples for SUMIF in the Formula Browser:

=SUMIF(A1:A5, “<5”,…

=SUMIF(A1:A5, “<5”,…

=SUMIF(D1:E3, “=c”, …

The condition must be expressed/presented as text. In the first three examples, this is accomplished by enclosing the comparison operator (<) and the number (5) or the comparison operator (=) and the letter (c) in quotes.

In Wayne's formula (which solves your question)

B1=SUMIF(A, "<="&TODAY(), B)

the TODAY() function can't e inside the quotes, because Numbers would then not recognize it as a function.

Placed outside the quotes, TODAY() returns the current date (and time, set to 00:00:00) value, and that value is joined to "<=" by the concatenation operator (&) to form a text expression readable by SUMIF.

Regards,

Barry

The formula I posted was:

=SUMIF(A, "<="&TODAY(), B)

I think you accidentally swapped the columns in your formula

The table I originally posted is much longer and was cut off by the screenshot:

where as the table you are using is limited to 16 rows:

the clue is that the row expand control (the circle with the "=" inside ) is visible

Wayne,

I wrote your formula on your table:

So, here the SUMIF is 105 in stead of 5356???

Paul.

Screenshot to prove I used your table, data and formula:

Paul.

There is no more data in your table. the sum of values 1 thru 14 is, in fact, 105