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