Sum values in one column based on values in another column and user input

I am trying to create a formula that sums one column based on the values in another and a user-defined start and stop. Let me try to explain:

A B
0 15
1 10
2 20
3 5
4 8
5 25
6 12

Start: 1
End: 4

The user inputs value for Start and Stop, then the function looks at column A, finds the value for start and stop, then sums everything from column B together from the start and stop points. So, the answer would be 43 in this example. Thanks in advance!!

Will the values in column A always be sorted as in your example?

If so, try this:

=SUMIFS(B:B,A:A,">="&E1,A:A,"<="&E2)

With 1 in E1 and 4 in E2.

Perfect! Thanks!

You're welcome. Happy to help.

If that solved your question, please mark this thread as SOLVED.