Need to lookup a value in a table and sum only the values relating to the month

[deadparrot]

Hi,

I have been scratching my head over this. I want to basically summarize daily data into monthly which would normally be a sumif, but I also want it to look up the Row first. In the example in bold (and attached) below I want a formula that looks up the row that the Apple is in and then add up all the values in Oct.

Oct Oct Oct Nov Nov Nov Dec Dec Dec
Apple 1 1 1 1 1 1 1 1 1
Banana 2 2 2 2 2 2 2 2 2
Carrot 3 3 3 3 3 3 3 3 3

Oct Nov
Apple 3 3
Banana 6 6

Any help or even just the formula to use would be great