COUNTIF with multiple criteria

  • Thread starter Thread starter schizoid_man
  • Start date Start date
S

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
 
Not a problem, COUNTIF doesn't work that way.

Try

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

as an example
 
Back
Top