I'm trying to sum up the "subtotals" for a set of numbers that occur at the same intervals but I don't want to say Sum(x1 + x2 +x3...). I thought their was a way to select one cell and do some kind of control alt something to have excel highlight all the cells that were equally spaced apart from one another. It's a huge spreadsheet and I'd rather not get carpel tunnel. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Summing numbers that are equally spaced apart
- Thread starter Danny318
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,336
- Office Version
- 365
- Platform
- Windows
What's the range of cells and how equally spaced apart are they?
Upvote
0
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,336
- Office Version
- 365
- Platform
- Windows
In what range?
Upvote
0
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,336
- Office Version
- 365
- Platform
- Windows
Perhaps:
=SUMPRODUCT(--(MOD(ROW(A31:A100)-ROW(A31),31)=0),A31:A100)
=SUMPRODUCT(--(MOD(ROW(A31:A100)-ROW(A31),31)=0),A31:A100)
Upvote
0
Similar threads
- Question
