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" wrote in message
...
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?