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

=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

=sumproduct((r2:r900="ag")*(am2:am900<0))
--
Don Guillett
SalesAid Software

"Iriemon" wrote in message
...


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

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

Thanks!



"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

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.

Glad to help

--
Don Guillett
SalesAid Software

"Iriemon" wrote in message
...
Couldn't get the COUNTIF statement below to work but the SUMPRODUCT
formula
works GREAT!

Thanks!



"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