COUNTIF with multiple criteria

[schizoid_man]

Hi,

I am trying to use COUNTIF with multiple criteria by joining the
conditions with an AND in the following form:
=COUNTIF(<range>,AND(<criteria1>,<criteria3>,<criteria2>))

The output of this formula is 0 every time, though I'm certain that
the formula itself contains no errors.

I am using Excel 2003. Is this a known problem with this version of
Excel?

Anuj

 

[Bob Phillips]

Not a problem, COUNTIF doesn't work that way.

Try

=SUMPRODUCT(--(rng1="value1"),--(rng2=value2))

as an example