=SUMPRODUCT(--(A2:A1000=country),--(B2:B1000=office type))

Needs to be a trange, not an entire column (Can't type A:A) and both pieces
must have the same range (2 - 1000 in the above example).

"ELP" wrote:

I'm trying to count the number of instances a combination of parameters occur.
i.e. column a = country, column b = office type.
I want to count the number of offices types in each country...

Please help!