Countif with multiple criteria

  • Thread starter Debbie Whitaker
  • Start date
D

Debbie Whitaker

Can you use Countif for more than one Criteria? For example, I want to count
all the "complaint" in column E with a charge number of "1000568625" in
column J.
 
P

Pete_UK

No, but try it this way:

=SUMPRODUCT((E1:E1000="complaint")*(J1:J1000="1000568625"))

If you have more than 1000 rows then increase this number, but you
can't have full column references unless you are using XL2007. I'm
assuming that your charge number is a text value - if not, just remove
the quotes.

Hope this helps.

Pete
 

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