Countif with multiple criteria

[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.

 

[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