Sum Corresponding Column

[tpcbrap]

I have a spreadsheet with two columns. I know the start value and end value of column A but would like to know the sum of the values between these two points on column B.

This is shown in the example below.
In this example I'd be looking for the sum of the values from B3:B9

Any help is massively appreciated!

Cheers

Screen Shot 2018-02-18 at 01.02.16.png

[Root_]

Try

=SUMIFS(B2:B11,A2:A11,">="&E2,A2:A11,"<="&E3)

[tpcbrap]

Cheers!!!! Been working on this for a while and was struggling big time. You have saved me you legend!!!! Love this website. Repped.