Using dates in SumIf

[gnossos]

I have a spreadsheet with dates in Col A and numbers in Col B. I want to sum all the numbers that are more recent than one year ago from today.

I get the general structure of the SumIf, and I can get it to work if I enter a specific date, for example: SumIf(A:A, ">03Aug2008", B:B).

But if it try to put some variable in the condition, like: ">Today()-365", I just get 0 for an answer.

How can I express the condition portion to select dates greater than one year ago from today?

Thanks,

Gnossos

 

[Claymationator]

You were just about there with your formula. Give this one a try:

=SUMIF(A:A,">"&TODAY()-365,B:B)

Hope that helps.

 

[gnossos]

Clamationator: That worked like a charm. Thank you.