View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Steven Cheng
 
Posts: n/a
Default Running Sum across columns but only to a certain point

I have a some values in three columns that basically snake from Day 1 to Day
45 and I will like to add them up starting from Day 1 going to a particular
Day that adds up to a value in another field.

Day1 $100,000.00 Day21 Day41
Day2 Day22 Day42
Day3 $5,000.00 Day23 Day43
Day4 $(5,000.00) Day24 Day44
Day5 $57,000.00 Day25 Day45
Day6 $80,000.00 Day26 Day46
Day7 $- Day27 Day47
Day8 $46,000.00 Day28 Day48
Day9 $- Day29 Day49
Day10 $- Day30 Day50
Day11 $80,000.00 Day31 Day51
Day12 $90,000.00 Day32 Day52
Day13 $10,000.00 Day33 Day53
Day14 Day34 Day54
Day15 Day35 Day55
Day16 Day36 Day56
Day17 Day37 Day57
Day18 Day38 Day58
Day19 Day39 Day59
Day20 Day40 Day60
what I want to return is the day in which it finally meets that particular
value.