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

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