countif (multiple criterias)

Hello

Im trying to count # of accounts or service locations per county.

Having some trouble trying to figure out a formula

Basially, I have county name in column C, and account # in column D

How can i go about doing this? apprecaite the help.

I have attached a sample.

cheers

Not entirely sure what you mean, but:

In Q6:
=COUNTIF(C:C,P6)

?

Looking again, because it seemed too simple to be true, I think I understand better what you mean.

How about:

=SUMPRODUCT(--($C$2:$C$5237=P6),--($E$2:$E$5237="Auto"))

?