Count function

[Martin]

Newbie question:

I just want to count how many items are marked with a (x)
but for a specific market(Europe)(in this example, i want
my return answer to be 3 (there is 4 Europe but only 3 are
marked with a x)). Please help..what would be the right
formula?

(A) (B)
Asia X
Europe X
Europe
Europe X
Europe
Asia
US
US
Europe X

 

[Bob Phillips]

Hi Martin,

=SUMPRODUCT((A1:A100="Europe")*(B1:B100))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)