COUNTIF with multiple criteria

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
 
B

Bob Phillips

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

Try

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

as an example
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top