=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.

Dave
--
Brevity is the soul of wit.


"Iriemon" wrote:



I'm trying to do a COUNTIF formula using two conditions.

=COUNTIF(AND(R2:R900="AG",AM2:AM900<0))

but the above formula doesn't work.

Any help would be apprecaited

Thanks