Formula to Sum Non-consecutive Numbers in a range

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Formula to Sum Non-consecutive Numbers in a range

  1. #1
    New Member
    Join Date
    Oct 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Formula to Sum Non-consecutive Numbers in a range

     
    Hi All,

    I'd like to take data in the range from B2:B500 and in C2 sum from B2:B9 and then in C3 sum from B10:B17 and in C4 sum from C18:C25 and so on. Does this make sense? Any help would be greatly appreciated.

    Thanks a lot!

  2. #2
    MrExcel MVP
    Moderator
    barry houdini's Avatar
    Join Date
    Mar 2005
    Location
    England
    Posts
    20,815
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to Sum Non-consecutive Numbers in a range

    Hello dschwister, welcome to MrExcel

    One way would be to use OFFSET function to sum every 8 cells, e.g. in C2 copied down

    =SUM(OFFSET(B$2,(ROWS(C$2:C2)-1)*8,0,8))

  3. #3
    New Member
    Join Date
    Oct 2011
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Formula to Sum Non-consecutive Numbers in a range

      
    Thanks so much Barry! That worked!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com