COUNTIF or SUM with nested IF's

[ROD]

Using Excel 2000, I need to check the range of cells at
A3:A65 to match a number found at A74. If that matches,
then it should count how many cells in range D365 have
values >=212. I have tried many combinations, but can't
seem to get it right. Help, please!

 

[firefytr]

according to specifications...

=IF(ISNUMBER(MATCH($A$74,$A$3:$A$65,0)),COUNTIF($D$3:$D$65,">="&212),"N
match")

hth

 

[Dave R.]

try

=SUMPRODUCT((A3:A65=A74)*(D365>=212))