How to add E6, and E8 through E38

[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?

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
(e-mail address removed)

 

[Wigi]

That should really work...

=SUM(E6,E8:E38)

 

[Bernard Liengme]

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

 

[CmK]

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

 

[Stan Brown]

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.

 

[lawrencae]

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
(e-mail address removed)

 

[lawrencae]

Sat, 5 Jan 2008 05:29:01 -0800 from lawrencae


It certainly should, though I would write =E6+SUM(E8:E38). What
exactly did you expect and what did you get?


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/