Adding a changing number of cells.

S

ScottJSP

I am trying to add up part of a row of numbers. The number of cells in the
row that I am trying to add will change depending on a variable in another
cell. For instance, if there are numbers in the range a1:t1, I am trying to
obtain the sum of the range that will always start with cell a1 and end with
?1 where "?" corresponds to a number in cell b1. The number in b1 is a
variable and will change occasionaly based on other conditions. So if the
number in cell b1 is "6" I would want the sum of a1:f1.

Does anyone have a suggestion?

Thanks,

Thanks
 
Top