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

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

"dellbad" wrote:

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

Toppers --

Thanks very much, it works.

"Toppers" wrote:

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

"dellbad" wrote:

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