Results 1 to 3 of 3

Formula to Sum Non-consecutive Numbers in a range

This is a discussion on Formula to Sum Non-consecutive Numbers in a range within the Excel Questions forums, part of the Question Forums category; Hi All, I'd like to take data in the range from B2:B500 and in C2 sum from B2:B9 and then ...

  1. #1
    New Member
    Join Date
    Oct 2011
    Posts
    7

    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
    19,954

    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

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

    Thanks so much Barry! That worked!

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