U
u473
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
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