Thread: How to add E6, and E8 through E38
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Wigi Wigi is offline
external usenet poster
  
Posts: 396
Default How to add E6, and E8 through E38
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

Reply With QuoteReply With Quote