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

Hello,

Can you post the whole formula?

Thanks,
JP

On Oct 22, 2:31 pm, jmcclain
wrote:
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

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


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

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



In article ,
jmcclain wrote:

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

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.))
--
HTH,

RD

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

Thanks to all for the assist.

"jmcclain" wrote:

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