try this idea. Note that you cannot (nor should you) use the entire column.
=SUMPRODUCT((A2:A22=TODAY()-365)*(A2:A22<=TODAY())*B2:B22)

--
Don Guillett
SalesAid Software

"ventuguy1488" wrote in message
...
Hi I am trying to track a rolling 1 year cycle of data and am using this
:=SUMIF(A:A,"="&TODAY()-364,M:M), but if you falsely add data above
todays
date for instance if i went to 03/07/07 and inputted data it computes also
I
tried taking the greater than out but that doesnt work any suggestions?