How can excel extract specific numbers to sum up?

For example, the number 89, I want to extract the sum between 60-89, is there a function to extract quickly

Welcome Guest.

How can excel extract specific numbers to sum up?

For example, the number 89, I want to extract the sum between 60-89, is there a function to extract quickly

+6

VotesA1=60

B1=89

C1 input

=SUM(ROW(INDIRECT(“$”&A1&”:$”&B1)) )

Then, press CTRL+SHIFT+ENTER

Jimmy Campbell- December 22, 2020 |

+5

VotesThis mathematical formula can be used

For example, A1 is 60, A2 is 89

You require the sum between them to be placed in A3

Then the formula is

=(A1+A2)*(A2-A1+1)/2

Lewis- December 23, 2020 |