# 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. ## 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. ## 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. ## Re: Formula to Sum Non-consecutive Numbers in a range

Thanks so much Barry! That worked!

#### Posting Permissions

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