Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
SUM function that ignores "#VALUE" and error entries?? | Excel Worksheet Functions | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
How do I use the "if" and "round" function in the same formula ? | Excel Worksheet Functions |