Conditional sum or Sumif?

Hi.

I'm trying to create a function to solve the following.

Column A contains numbers representing years. Column B contains numbers representing population. Each year number in A has a corresponding population # in B. I'm trying to sum the numbers in B that correspond to years between 20 & 30.

Exl:

A B
15 5
20 6
25 7
30 6
35 5

The result I'm looking for would be sum(6+7+6) = 19

Any help is greatly appreciated.

Thank you.

Try this

=SUMPRODUCT(--($A:$A>=20)*($A:$A<=30),$B:$B)

=sumproduct(--($a$1:$a$5>=20),--($a$1:$a$5<=30),$b$1:$b$5)

Ah ha. Thank you all very much. This is exactly what I was trying to do.