summarize values between 2 years

I want to know how I can summarize the number of "1" in column 3 that are between the date in column 4 and column 5, as I show in the attach file

in column "O" is the first year and in column "P" the end year. I want to sum the column F between that range.

Thanks in advance!

Is this what you want?

=SUMIFS(F:F,B:B,">="&O25,B:B,"<="&P25)

or this (if using version below Excel 2007):

=SUMPRODUCT((B4:B44>=O25)*(B4:B44<=P25)*(F4:F44))