rolling 12 data
 

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?

rolling 12 data
 

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?

rolling 12 data
 

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

rolling 12 data
 

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?

rolling 12 data
 

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?

rolling 12 data
 

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?

rolling 12 data
 

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?

rolling 12 data
 

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?

rolling 12 data
 

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

Regards,
Bernd