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?

I have tried =SUM(E6,E8:E38), which did not seem to work. Perhaps that fact
that E8 through E38 also includes =C8+D8, which is repeated through C38+D38.

Lawrence S. Miller

That should really work...

=SUM(E6,E8:E38)


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"lawrencae" wrote:

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?

I have tried =SUM(E6,E8:E38), which did not seem to work. Perhaps that fact
that E8 through E38 also includes =C8+D8, which is repeated through C38+D38.

Lawrence S. Miller

Please expand on 'did not seem to work"; what is in E6 what was the result
of =SUM(E8:E38) and =SUM(E6,E8:E38)
Is it possible that E6 has a text value pretending to be a number? What is
the result from =ISNUMBER(E6)?
I think I would have use the simple formula =SUM(E8:E38) + E6 but there is
nothing inherently wrong with =SUM(E6,E8:E38),
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

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

I have tried =SUM(E6,E8:E38), which did not seem to work. Perhaps that
fact
that E8 through E38 also includes =C8+D8, which is repeated through
C38+D38.

Lawrence S. Miller

Try =sum(e8:e38)+e6
but =SUM(E6,E8:E38) should work


"lawrencae" wrote:

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?

I have tried =SUM(E6,E8:E38), which did not seem to work. Perhaps that fact
that E8 through E38 also includes =C8+D8, which is repeated through C38+D38.

Lawrence S. Miller

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/

Okay, Stan, I am downloading Dinner at Eight with Jean Harlow. You made me do
it!
I am an American in the Philippines, I may write you later through your
website, if I can remember the tags I used in del.icio.us for it, to ask you
a question or two about upstate NY and the general area. I am thinking about
moving there in July with my wife in tow. My home ground is SoCal.

Lawrence


"Stan Brown" wrote:

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/

"Stan Brown" wrote:

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/