X

#### xsrossiter

I am using Excel 2002 SP3 and hope to find a conditional solution

using formulas rather than a macro. In column A are a series of

values, column B has values at irregular intervals, and column C

contains calculated values based on a value in column B until a new

value in column B is encountered and then it incorporates the new

column B value in its calculation.

A B C

2 3 5

6 9

8 11

4 2 6

15 17

8 10

21 8 29

For example, column C contains a formula to sum columns A and B. It

adds 3 to whatever value is in column A until the fourth row at which

point it adds 2 to whatever value is in the A column and finally as it

gets to the seventh row begins adding 8 to A column values.

Is there some formula that can be placed in column C that will follow

this logic and avoid using a macro? Column A at this point has 86 rows

and column B has 14 values at varying intervals.

Thanks for your help and time.

Steve