Formula error in "sum" function

[Guest]

I am trying to sum a large group of non-contiguous cells. Such as
+sum(A1,A4,A23) etc...

Is there a limit to the number of "parts" to the formula?

I am getting an error, but it is non-descript and only highlights a cell
reference in the formula. I deleted the highlighted cell reference, but I got
the same error again, this time with the next cell reference highlighted.

Is there another way to accomplish this?

This is part of a master file that contains 20 years worth of data and I
need to avoid any major revision to it.

Thanks

 

[JP]

Hello,

Can you post the whole formula?

Thanks,
JP

 

[Niek Otten]

From Excel HELP:

SUM(number1,number2, ...)

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


--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I am trying to sum a large group of non-contiguous cells. Such as
| +sum(A1,A4,A23) etc...
|
| Is there a limit to the number of "parts" to the formula?
|
| I am getting an error, but it is non-descript and only highlights a cell
| reference in the formula. I deleted the highlighted cell reference, but I got
| the same error again, this time with the next cell reference highlighted.
|
| Is there another way to accomplish this?
|
| This is part of a master file that contains 20 years worth of data and I
| need to avoid any major revision to it.
|
| Thanks

 

[JE McGimpsey]

Like other formulae, there's a limit of 30 arguments. You can get around
this in the SUM() function by grouping arguments within parentheses:

=SUM((A1,A4,A23), (A40,A44,A45), ...)

 

[RagDyer]

If you're trying to sum more then 30 cells, just enclose the arguments in
*double* parens.

=Sum((1,2,3,...50,51,52,...etc.))

 

[Guest]

Thanks to all for the assist.