How to sum a data range thru and after a cut off date
 

How do I sum a Data range thru and after a cut off date ?
i.e. Cut Off Date is in cell B2 and is equal (after formatting) to
8/23.
The expected result in Column Done, Item B, thru the 23rd is 400,
and in Column ToGo, Item A, after the 23rd is 300.
The calendar starts in D2, last Column unknown.
The Data itself starts in Row 3, Last row unknown.
Cut off Date : 8/23
Item Done ToGo 8/21 8/22 8/23 8/24 8/25 ...
A 80 40 60 20 40
B 400 300 140 100 160 120 180 ...
....
....
Help appreciated,
Celeste

How to sum a data range thru and after a cut off date
 

=SUMIF(A3:A2000,"<="&B2)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"u473" wrote in message
ups.com...
How do I sum a Data range thru and after a cut off date ?
i.e. Cut Off Date is in cell B2 and is equal (after formatting) to
8/23.
The expected result in Column Done, Item B, thru the 23rd is 400,
and in Column ToGo, Item A, after the 23rd is 300.
The calendar starts in D2, last Column unknown.
The Data itself starts in Row 3, Last row unknown.
Cut off Date : 8/23
Item Done ToGo 8/21 8/22 8/23 8/24 8/25 ...
A 80 40 60 20 40
B 400 300 140 100 160 120 180 ...
...
...
Help appreciated,
Celeste

How to sum a data range thru and after a cut off date
 

Sorry I made a mistake in my text, the Cut off Date is in Cell B1, but
your
solution does not fit the problem. I know it involves the sum a a
flexible range
driven by the date Offset but I do not master the syntax.
Thank you for your response,
Celeste.