SUMIF and TODAY()

[jacol]

Hi

I need some help to try and nut out the use of dates with SUMIF.

I need to sum a range of values where the corresponding date for a value is less than the current date. For example:


untitled.JPG

Todays date = 18/5/12

Dates Value
1/4/12 5
23/4/12 6
1/3/12 5
9/2/12 9
23/6/12 8
12/12/12 7

I have tried to use the following SUMIF formulas but without success.

=SUMIF(A6:A28,"<=TODAY()",B6:B28)
or
=SUMIF(A6:A28,"<=A1",B6:B28)

If i write the formula as =SUMIF(A6:A28,"<=18/5/12",B6:B28) it works ok

If someone can help that would be appreciated

[Cutter]

This way

=SUMIF(A6:A28,"<="&TODAY(),B6:B28)
or
=SUMIF(A6:A28,"<="&A1,B6:B28)

[jacol]

Thankyou so much for your prompt reply, much appreciated. works fine

[Cutter]

You're welcome. Don't forget to mark your thread as SOLVED (if instructions needed click on Forum Rules @ top of page and see rule #9).