Hi Clark

Try
=SUMPRODUCT((A1:F1=TODAY())*(A1:F1<=TODAY()+14)*A 2:F2)

--
Regards

Roger Govier


"Clark" wrote in message
...
I am trying to come up with a formula that will calculate projected
usage as
dates change. Example I want a formula that would say that in the
first 3
time periods below "using todays date as the reference point(1 June
foe
example) group all projected usage for the next 3 weeks." The desired
result
is 3 below. Then lets say that a week later (June 8) the same formula
would
return a result of 4 (the expected usage for the time period covering
8 June
to 22 June) any suggestions?


6/1/2007 6/8/2007 6/15/2007 6/22/2007 6/29/2007 7/6/2007
1 1 1 2 1 1

--
Clark