View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stacy C[_2_] Stacy C[_2_] is offline
external usenet poster
 
Posts: 14
Default Summing +30 Non-adjacent cells

Good afternoon,

I need to sum over 30 cells which are nonadjacent. However, they are evenly
spaced (the first cell is D4, and then H4, and soforth, through FH4).

Currently, I am simply using the SUM function and various "embedded" SUMs,
but this is very long and tedious to input (not to mention, looks horribly
sloppy in the Fx field). Is there a simpler way to tally this information?

Thank you again for your kind support.