Steve, Lets assume that your columns are labeled A, B & C. meaning that cell A2=2, B2=3, C2=5
put this formula in cell C2, =IF(B2="",A2+C1-A1,B2+A2) Copy that formula down. Michael On Aug 28, 12:43 am, xsrossiter <steverossi...@sbcglobal.net> wrote: > Hello, > > 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 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe