Count with two criteria

[ibf]

Hi everybody

I can't seem to figure out how to do a count from two columns with specific criteria. Here goes.
I have one column with city names(A) and several other columns (B - D) with areas of service. Some of the service column may or may not have amounts in them.

A B C D
1 City Furniture Carpets Area Rugs
2 Cobourg $ 140.00
3 Ajax $ 89.00
4 Pickering
5 Cobourg $ 234.00

What I would like to find out is the count for each city for each service.
ei Cobourg should return 2 for furniture

I've tried =SUMPRODUCT(($A$2:$A$5="Cobourg")*((B2:B5=">1"))
I've also tried various Countif formulas.

Please Help. ibf

 

[Oaktree]

Try:

=SUMPRODUCT(($A$2:$A$5="Cobourg")*((B2:B5>1))

Or, consider using a pivot table.

 

[ibf]

Thanks Oaktree
That worked. I new I was close. Thanks for your help.
ibf