I am looking to use the sumifs function to sum the values of the codes between a specific full range, and for a specific period.

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, a list of values column B, and a list of periods column C.

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

I want to add up all of column B, between the range 2 to 5, for a specific period (say 8).

I am using =SUMIFS(B1:B6,A1:A6,">"&D1,A1:A6,"<"&E1) to sum A depending on the B range, but wondered if I could add an additional criteria (period) column C. It would be alot easier for the users of the spreadsheet if this was possible.

Hope this makes sense.

Thanks