Thread: Sum numbers between two specific cells Thanks: 0 Likes: 0

1. Re: Sum numbers between two specific cells

It works in the first row (row2) but when I drag down it does not work in any of the following rows  Reply With Quote

2. Re: Sum numbers between two specific cells

It’s going to be searching for 8 and 6 if you drag it down. Are you meaning to search for those same numbers in each row?  Reply With Quote

3. Re: Sum numbers between two specific cells Originally Posted by Dan1000 The value would be 10 if the question was to sum the numbers between 8 and 6 in this instance. Always 9 cells next to each other. Always the numerals 1 to 9 in each of the cells.
Hi, here is a formula based option you can try.

Excel 2013/2016
ABCDEFGHIJKLM
1Num 1Num 2Result
28712639548610

Sheet1

Worksheet Formulas
CellFormula
M2=SUM(INDEX(A2:I2,MATCH(K2,A2:I2,0)):INDEX(A2:I2,MATCH(L2,A2:I2,0)),-K2,-L2)  Reply With Quote

4. Re: Sum numbers between two specific cells

Edit: Oops, FormR posted basically same thing while I was composing my post. See if this is any use. It doesn't matter whether the 2 specified numbers are in the correct order (left to right) or not. It should sum the cells between anyway.

Sum Between

 A B C D E F G H I J K L M 1 Between 1 Between 2 Result 2 8 7 1 2 6 3 9 5 4 8 6 10 3 6 7 1 2 8 3 9 5 4 8 6 10 4 5 6 2 1 4 7 9 3 8 6 2 0 5 5 6 2 1 4 7 9 3 8 5 8 32

 Cell Formula M2 =SUM(INDEX(A2:I2,MATCH(K2,A2:I2,0)):INDEX(A2:I2,MATCH(L2,A2:I2,0)))-SUM(K2:L2)

Excel tables to the web >> Excel Jeanie HTML 4  Reply With Quote

5. Re: Sum numbers between two specific cells Originally Posted by FormR Hi, here is a formula based option you can try.

Excel 2013/2016
A B C D E F G H I J K L M
1 Num 1 Num 2 Result
2 8 7 1 2 6 3 9 5 4 8 6 10
Sheet1

Worksheet Formulas
Cell Formula
M2 =SUM(INDEX(A2:I2,MATCH(K2,A2:I2,0)):INDEX(A2:I2,MATCH(L2,A2:I2,0)),-K2,-L2)
Now you're a grand master...don't think, feeeeeeel!...thank you soooooo much

Dan  Reply With Quote

6. Re: Sum numbers between two specific cells

Thanks Peter. Always find your help with Excel top notch! No worries getting there after the grand master  Reply With Quote

7. Re: Sum numbers between two specific cells Originally Posted by Dan1000 Thanks Peter. Always find your help with Excel top notch! No worries getting there after the grand master
No problem. Glad you got a successful outcome.   Reply With Quote

User Tag List

Tags for this Thread

cell, cells, number, specific, sum  Posting Permissions

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