Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summming a Data range through a cutoff date ?
How do I sum a Data range through a cutoff date ?
I thought I had submitted a common problem but got no response. .. I have a varying CutOff Date in cell B1 currently equal to 8/23 (after formatting). The calendar starts in C2, last Column unknown. The Data itself starts in Row 3, Last row unknown. .. I want to loop through each row and fill in the column B the sum of the range from Column C through the Cutoff Date Column. .. The expected result in Column B (Done) will be 80 for Item Y and 400 for Item Z. .. Cut off Date : 8/23 Item Done 8/21 8/22 8/23 8/24 8/25 ... Y 80 60 20 40 Z 400 140 100 160 120 180 ... .... .... Can you help me ? Thank you, Celeste |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutoff Time for Changes | Excel Discussion (Misc queries) | |||
Cutoff score for acceptance | Excel Worksheet Functions | |||
Text is cutoff in a cell | Excel Discussion (Misc queries) | |||
Excel "Value (Y) Axis" is cutoff--Fix it! | Charts and Charting in Excel | |||
CUTOFF | Excel Discussion (Misc queries) |