View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default How to add E6, and E8 through E38

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/