Gord has given a neat solution. Another is
=SUM(cell1, cell2,.....celln)+SUM(celln=1, cellN+2)
But since there are not in a range why not use a simple formula similar to:
=A1+C3+D5+F5+G6+H7........
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Sue" wrote in message
...
We're trying to get the sum of about 60 cells [not in a range,
unfortunately]
on an enormous spreadsheet. As the cells references are entered into the
formula the cells are outlined in color and the cell reference in the
formula
turns a corresponding color. All good. After about 30 entries, the cells
are no longer being highlighted and the cell references are in black.
After
entering all of the cell references in the formula and closing with the
parenthesis, we hit enter and get an error message. I can't tell you the
exact wording since it's my boss's spreadsheet and she decided to work it
out
with subtotals and totals of subtotals. But there must be a reason and
I'd
like to know what it is - and how to fix it. Thanks.
--
Sue