For some reason, this doesn't work. I just get a 0 returned.

Initially when I tried this formula, I got #NAME, so i added inverted commas
thus:
=SUMPRODUCT(--(A2:A1000="country"),--(B2:B1000="office type"))
Obviously changing the word "country" to "UK" etc, and "office type" to
"service" etc. to match the list.

Then I took note of your second point about tranges, so changed the formula
thus:
=SUMPRODUCT(--(A2:B1000="country"),--C2:D1000="office type"))
and then tried a third variation on the same theme thus:
{=SUMPRODUCT(--(A2:A1000=country),--(B2:B1000=office type))}

The only thing that ever gets returned is a big fat 0!

Where am I going wrong?

"Sean Timmons" wrote:

=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!