All sugestions worked. I feel stupid because after nothing worked I kept
checking and all the nembers were saved as text.

"pinmaster" wrote:

Hi Jr

The only reason I can think of that would cause this formula
=sum(d1419:d1555) not to work is if you had some kind or errors in your data,
something like #N/A or DIV/0! or mnay others... so try something like this:

=SUMIF(D1419:D1555,"<#N/A",D1419:D1555)

HTH
Jean-Guy




"Jr" wrote:

I tried using =sum(d1419:d1555) but that didn't work. I will try the extra
parenthesis
thanj you
"Peo Sjoblom" wrote:

=SUM((a1,a3,a5 and so on up to 30),a50,a55 and so on))

just wrap each set of 30 in extra parenthesis

if you mean sum a contiguous range, use

=SUM(A1:A150)

Regards,

Peo Sjoblom

Jr wrote:
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.