COUNTIF & AND Functions

I

Iriemon

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
 
D

Dave F

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

Iriemon

Couldn't get the COUNTIF statement below to work but the SUMPRODUCT formula
works GREAT!

Thanks!
 
H

Harlan Grove

Dave F said:
=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.
Click to expand...
....

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