setting a range based on a value of a cell
what i am trying to do is add a range of cells in a column ending with the current row and beginning with a variable number of previous rows.
in english
the beginning row = (the current row - the value of a cell in the previous column in the current row).
if column to be totaled = B, current row = 6, the value in A6 = 3
the range would be = B(6 - 3) or B3:B6 in other words =SUM(B3:B6)
How do i get there?
in english
the beginning row = (the current row - the value of a cell in the previous column in the current row).
if column to be totaled = B, current row = 6, the value in A6 = 3
the range would be = B(6 - 3) or B3:B6 in other words =SUM(B3:B6)
How do i get there?
ibook g4, macbook, Mac OS X (10.5.4)
