COUNTIF or SUM with nested IF's

  • Thread starter Thread starter ROD
  • Start date Start date
R

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 D3:D65 have
values >=212. I have tried many combinations, but can't
seem to get it right. Help, please!
 
according to specifications...

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

hth
 
Back
Top