[SOLVED] How do I increase the number of additions etc.from 30

1. [SOLVED] How do I increase the number of additions etc.from 30

It appears that I cannot add up more than 30 cells at a time.

Is this true and/or is there a way round it?

2. Re: How do I increase the number of additions etc.from 30

Definitely FALSE.

How are you trying to add? If your formula is something like =a1+a2+a3..
you may have hit the ?255 character maximum for a formula. If the cells you
want to add are in a contiguous block(s) it would be better to use something
like =sum(a1:z999).

Regards.

Bill Ridgeway
Computer Solutions

"leonperrins" <leonperrins@discussions.microsoft.com> wrote in message
news:44C1371C-30E3-4C3B-B898-7EBC257E2D22@microsoft.com...
> It appears that I cannot add up more than 30 cells at a time.
>
> Is this true and/or is there a way round it?

3. Re: How do I increase the number of additions etc.from 30

Hello Bill,
I,m trying to analyse a 'phone bill so they are straight additions but not
contiguous.
I found the following:-
Adds all the numbers in a range of cells.

Syntax

SUM(number1,number2, ...)

Number1, number2, ... are 1 to 30 arguments for which you want the total
value or sum.

How do I change the "255" figure?

"Bill Ridgeway" wrote:

> Definitely FALSE.
>
> How are you trying to add? If your formula is something like =a1+a2+a3..
> you may have hit the ?255 character maximum for a formula. If the cells you
> want to add are in a contiguous block(s) it would be better to use something
> like =sum(a1:z999).
>
> Regards.
>
> Bill Ridgeway
> Computer Solutions
>
> "leonperrins" <leonperrins@discussions.microsoft.com> wrote in message
> news:44C1371C-30E3-4C3B-B898-7EBC257E2D22@microsoft.com...
> > It appears that I cannot add up more than 30 cells at a time.
> >
> > Is this true and/or is there a way round it?

>
>
>

4. Re: How do I increase the number of additions etc.from 30

The limit is 1024 (when in R1C1 reference style).

You could use:

=sum(sum(a1,b1),sum(e1,g1),sum(q1,v1)

You can use 30 arguements in each sum().

If the cells that are in the range are non-numeric, you can still use:
=sum()

It'll ignore those text entries.

leonperrins wrote:
>
> Hello Bill,
> I,m trying to analyse a 'phone bill so they are straight additions but not
> contiguous.
> I found the following:-
> Adds all the numbers in a range of cells.
>
> Syntax
>
> SUM(number1,number2, ...)
>
> Number1, number2, ... are 1 to 30 arguments for which you want the total
> value or sum.
>
> How do I change the "255" figure?
>
> "Bill Ridgeway" wrote:
>
> > Definitely FALSE.
> >
> > How are you trying to add? If your formula is something like =a1+a2+a3..
> > you may have hit the ?255 character maximum for a formula. If the cells you
> > want to add are in a contiguous block(s) it would be better to use something
> > like =sum(a1:z999).
> >
> > Regards.
> >
> > Bill Ridgeway
> > Computer Solutions
> >
> > "leonperrins" <leonperrins@discussions.microsoft.com> wrote in message
> > news:44C1371C-30E3-4C3B-B898-7EBC257E2D22@microsoft.com...
> > > It appears that I cannot add up more than 30 cells at a time.
> > >
> > > Is this true and/or is there a way round it?

> >
> >
> >

--

Dave Peterson

5. Re: How do I increase the number of additions etc.from 30

"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:42BFEA09.B71B3AB4@netscapeXSPAM.com...
> The limit is 1024 (when in R1C1 reference style).
>
> You could use:
>
> =sum(sum(a1,b1),sum(e1,g1),sum(q1,v1)
>

A little more simply with

=SUM((a1,b1,c1, etc),(e1,g1, etc))

that is group them within the SUM itself

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1