Me too.
Thanks Gord.
--
Regards
Roger Govier
"Bernard Liengme" wrote in message
...
That a new one on me - maybe my worksheets are too tidy <g
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
That's too hard Bernard........entering all those "+" signs and clicking
cells<g
Hit SHIFT + F8 then =SUM(( and click your way around. Excel adds the
commas.
Gord
On Thu, 18 Jun 2009 17:08:08 -0300, "Bernard Liengme"
wrote:
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