Dave F wrote...
=COUNTIF(AND(R2:R900="AG",AM2:AM900<"0"))

For reasons known only to Bill Gates COUNTIF requires that number values be
enclosed in double quotes.
....

And for reasons known only to you, you didn't test this ti find out
that it can't even be entered as-is in any version of Excel. It's a
great big syntax error.