Sumifs that includes additional criteria

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

Hopefully I have attached a sample DB file? It should make more sense now.

I want to sum a range of codes in the I&E workbook (for which I am using a SUMIFS formulas), but I would prefer to only sum the Period 8 data. All of the information being retrieved is in the Actual 2012 workbook.

Hope this is clearer now.

Thanks

Excellent, Thank you all.

How would this forumla change if I wanted to sum a specific account code (instead of a from to range), and the period 8?

Sorry, I should have made it clearer.

I want to add up the values of one code (say 0500) in period 8 (alternatively add up a number of individual codes) in period 8.

Sample workbook attached.