Counting Data From 2 Different Columns

[Guest]

Please see example below:

Fiscal Year Lead Time (Days)
======================
FY05 11
FY05 23
FY05 16
FY06 14
FY06 21
FY06 35
FY07 8
FY07 26
FY07 33
======================

I need a formula that will allow me to count the # of records above that are
(for example) in FY05 and fall between 10 and 20 days. The answer should be
(2).

Thanks in advance for you help.

Dellbad

 

[Guest]

=SUMPRODUCT((A1:A9="FY05")*(B1:B9>=10)*(B1:B9<=20))

 

[Guest]

Toppers --

Thanks very much, it works.

=SUMPRODUCT((A1:A9="FY05")*(B1:B9>=10)*(B1:B9<=20))