COUNTIF & AND Functions
 

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 Functions
 

=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

COUNTIF & AND Functions
 

=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

COUNTIF & AND Functions
 

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

COUNTIF & AND Functions
 

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.

COUNTIF & AND Functions
 

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