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?

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?

=SUMPRODUCT(--(A2:A9=EDATE(TODAY(),-12)),--(A2:A9<=TODAY()),B2:B9)


"ventuguy1488" wrote:

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?

Hi

You could just add a second Sumif to the formula
=SUMIF(A:A,"="&TODAY()-364,M:M)-SUMIF(A:A,""&TODAY(),M:M)

Did you really mean 364 and not 365?


--
Regards

Roger Govier


"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?

today -364 == 365 right? But i found if i didnt format the date beyond todays
date i didnt have this problem but thanks all

"Roger Govier" wrote:

Hi

You could just add a second Sumif to the formula
=SUMIF(A:A,"="&TODAY()-364,M:M)-SUMIF(A:A,""&TODAY(),M:M)

Did you really mean 364 and not 365?


--
Regards

Roger Govier


"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?

I am trying to fomat the whole column so that it just keeps traking the daily
data for the last year

"Don Guillett" wrote:

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?

what is edate? Also u have partial columns i need the whole column but can i
use this for a rolling 12 mnth total vrs a rolling 365?
"Teethless mama" wrote:

=SUMPRODUCT(--(A2:A9=EDATE(TODAY(),-12)),--(A2:A9<=TODAY()),B2:B9)


"ventuguy1488" wrote:

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?

None of your posts fully tell us what you are trying to do. If you have a
final solution please post it here for the benefit of others.
--
Don Guillett
SalesAid Software

"ventuguy1488" wrote in message
...
I am trying to fomat the whole column so that it just keeps traking the
daily
data for the last year

"Don Guillett" wrote:

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?

Without Analysis TP:
=SUMPRODUCT(--
(A1:A999DATE(YEAR(TODAY()-1,MONTH(TODAY()),DAY(TODAY())),--
(A1:A999<=TODAY()),B1:B999)

Regards,
Bernd