[RESOLVED]Adding entire column in Excel

I have a list so the number of rows will be increasing. I do not want to keep changing the algorithm for the sum so i would like to know one that will include all the number put in the same column. I think I may have done this before but I do not remember what i had done. thanks

ian

nevermind i figured it out. i just made it a range and i picked a range larger than i knew i would be adding

Code:

---

=SUM(B1:B150)

---

Just do this:

Code:

---

=SUM(B:B)

---

thats even better. thanks.