or even

=SUM(A:A)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Jr" wrote in message
...
I'm triing to add up every thing in one column but I can get past 30 rows.
is
there a way of increasing the number. In my speadsheet I have about 1500
rows
and I'm triing to add up 100 to 150 rows at a time.