Sat, 5 Jan 2008 05:29:01 -0800 from lawrencae
:
I have argument =SUM(E8:E38), which works, want to add E6 to the
SUM, so How do I add E6, and E8 through E38?
=E6+SUM(E8:E38)
I have tried =SUM(E6,E8:E38), which did not seem to work.
It certainly should, though I would write =E6+SUM(E8:E38). What
exactly did you expect and what did you get?
Perhaps that fact that E8 through E38 also includes =C8+D8, which
is repeated through C38+D38.
Sorry, I have no idea what that sentence means.
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/