Someone who is smarter than me

[reload]

I think I need to declare a variable.

Because as it sits would be like this:

A1 = 50    B1 = [blank]
A2 = 75    B2 = 125
A3 = 100  B3 = 225
A4 = 125  B4 = n
How can I compute the next blank cell in col B using the value of the current cell of col A + the previous of col B?

[reload]

Got it.

50   
75   125
100   225
125   350
150   500
175   675
200   875
225   1100
250   1350
275   1625
300   1925
325   2250
350   2600
375   2975
400   3375
425   3800
450   4250
475   4725
500   5225
525   5750
550   6300
575   6875
600   7475
625   8100
650   8750
675   9425
700   10125
725   10850
750   11600
775   12375
800   13175
825   14000
850   14850
875   15725
900   16625
925   17550
950   18500
975   19475
1000   20475
1025   21500
1050   22550
1075   23625
1100   24725
1125   25850
1150   27000
1175   28175
1200   29375
1225   30600
1250   31850
1275   33125
1300   34425
1325   35750
1350   37100
1375   38475
1400   39875
1425   41300
1450   42750
1475   44225
1500   45725
1525   47250
1550   48800
1575   50375
1600   51975
1625   53600
1650   55250
1675   56925
1700   58625
1725   60350
1750   62100
1775   63875
1800   65675
1825   67500
1850   69350
1875   71225
1900   73125
1925   75050
1950   77000
1975   78975
2000   80975
2025   83000
2050   85050
2075   87125
2100   89225
2125   91350
2150   93500
2175   95675
2200   97875
2225   100100
2250   102350
2275   104625
2300   106925
2325   109250
2350   111600
2375   113975
2400   116375
2425   118800
2450   121250
2475   123725
2500   126225
2525   128750

[reload]

Set the next blank cell in Col B as "= (A3+B2)" and repeat growth trend.

[1980c10]

 Was going to say reference it without the "$" and it should move down the column plus write a new formula

[reload]

Was going to say reference it without the "$" and it should move down the column plus write a new formula

Yep yep.  The sad part is, I own my own business as a website developer, I know and LOVE php, html, javascript, and css but for the life of me I never played around with Excel.

[1980c10]

I'm convinced someone could work with it a lifetime and never learn all of its capabilities. I have written several formulas 6-8 lines long for payroll calculations etc. The challenge is kind of fun getting the formula to work. Once you get it though it's nice to make calculators for mortgage or car payments or retirement accts. I think the key is to learn well above the level you plan to use it and then everything seems pretty basic.

[Irish_Alley]

i make our count sheets on excel and i share them with everyone but it only takes one miss click or idiot to screw it all up lol sorry i had to get off before and just got back on didnt mean to bail on you but glad you got it figured out

[Bitzer!]

I love it! I use several "back pages" that when data is entered it automatically adjusts the "cover page"
You can pretend it's taken ages to produce documents etc when it can do it all for you