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.

=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.

=SUM(A1:A150)

--
---
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.

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.

Are you entering the rows individually?

=SUM(A1,A2,A3,... etc.)
OR
=A1+A2+A3 ... etc.
You can group contiguous cells together.

=SUM(A1:A25,A45:A75,... etc.)

If, on the other hand, *all* your cells are *not* adjoining,
You can use something like this:

=SUM((A1,A3,A7,A10,A20,A24,...etc.))

Where the *double* parenthesis allow you to exceed the 30 argument
restriction.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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.

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.

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.

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.

Jr

What is "didn't work"? Error message? No SUM? Noises from your Hard Drive?

=SUM(D1419:D1555) is the standard method of summing a range.

Maybe your numbers are not numbers but text that look like numbers.

Post back.

Summing 30 cells at a whack for 100 to 150 cells is a lot of typing.


Gord Dibben MS Excel MVP


On Thu, 4 Jan 2007 17:05:00 -0800, 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.

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you


"Gord Dibben" wrote:

Jr

What is "didn't work"? Error message? No SUM? Noises from your Hard Drive?

=SUM(D1419:D1555) is the standard method of summing a range.

Maybe your numbers are not numbers but text that look like numbers.

Post back.

Summing 30 cells at a whack for 100 to 150 cells is a lot of typing.


Gord Dibben MS Excel MVP


On Thu, 4 Jan 2007 17:05:00 -0800, 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.

Looks like it does not have to be grouped in sets of 30.
=SUM((a1, a3, up to 50),a51) works okay.


"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.

Thanks for letting us know you're sorted out and the fix you needed.


Gord

On Thu, 4 Jan 2007 19:21:00 -0800, Jr wrote:

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you


"Gord Dibben" wrote:

Jr

What is "didn't work"? Error message? No SUM? Noises from your Hard Drive?

=SUM(D1419:D1555) is the standard method of summing a range.

Maybe your numbers are not numbers but text that look like numbers.

Post back.

Summing 30 cells at a whack for 100 to 150 cells is a lot of typing.


Gord Dibben MS Excel MVP


On Thu, 4 Jan 2007 17:05:00 -0800, 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.

He did ... 26 minutes before you posted <G


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Thanks for letting us know you're sorted out and the fix you needed.


Gord

On Thu, 4 Jan 2007 19:21:00 -0800, Jr wrote:

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you

I think Gord syncs his newsreader only a couple of times a day.<vbg
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Bob Phillips" wrote in message
...
He did ... 26 minutes before you posted <G


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Thanks for letting us know you're sorted out and the fix you needed.


Gord

On Thu, 4 Jan 2007 19:21:00 -0800, Jr wrote:

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you

My posting was in response to OP's post saying he had fixed the problem so it is
obvious I knew "he did".

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you

Did you think my post was written in a sarcastic manner?

It was a genuine thank you.


Gord

On Fri, 5 Jan 2007 10:43:09 -0000, "Bob Phillips" wrote:

He did ... 26 minutes before you posted <G


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Thanks for letting us know you're sorted out and the fix you needed.


Gord

On Thu, 4 Jan 2007 19:21:00 -0800, Jr wrote:

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you

no definite solution or formula for adding a column

"Gord Dibben" wrote:

Thanks for letting us know you're sorted out and the fix you needed.


Gord

On Thu, 4 Jan 2007 19:21:00 -0800, Jr wrote:

You were right the numbers were stored as text. Once I fixed that then the
formulars worked. Thank you


"Gord Dibben" wrote:

Jr

What is "didn't work"? Error message? No SUM? Noises from your Hard Drive?

=SUM(D1419:D1555) is the standard method of summing a range.

Maybe your numbers are not numbers but text that look like numbers.

Post back.

Summing 30 cells at a whack for 100 to 150 cells is a lot of typing.


Gord Dibben MS Excel MVP


On Thu, 4 Jan 2007 17:05:00 -0800, 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.