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?
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?
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?
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?
>
>
>
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
"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)
Bookmarks