Sumif of a range i.e between account codes 100 - 500

I am looking to use the sumif function for to sum the values of the codes between a specific full range.

I have simplified this example, but the information comes from an accounts code structure. It is an I&E with an slighly unstructured coding format.

I have a list of codes column A, and a list of values column B.

A B
1 50
2 150
3 200
4 150
5 149
6 132

I want to add up all of column B, between the range 2 to 5.

Thanks, can this be acheived by linking into a cell instead of saying ">2", can I select a cell so that the amending the accounts code can be flexible. Tried referencing a cell, but no joy???

You didn't read Jeff's post fully.

He said you could use a cell reference instead of saying ">2" and showed you how to do it with this example:

=SUMIFS(B1:B6,A1:A6,">"&D1,A1:A6,"<"&E1)
D1 (or whatever cell you choose) would hold the lower value
E1 (or whatever cell you choose) would hold the higher value

Excellent, just what I was looking for thank you both.

You're welcome. Don't forget to mark your thread as Solved (click on Forum Rules @ top of page and see instructions in rule #9).

And you should click on the small star icon at the bottom left corner of Jeff's post to thank him.