The country of Africa? :-)

--
HTH

-------

Bob Phillips
"Dave R." wrote in message
...
try this;

=sumproduct(--(a1:a4000="africa"),--(b1:b4000="Y"))


wrote in message
...
Hi, Pivot will not be adequate. Its a worksheet which is
always being updated.. ie the numbers always change. I
was looking to put a formual at the bottom.



-----Original Message-----
HI Everyone, Can you help.
Column A has several countries listed. Column B has Y
(for Yes) or N (for No). There are over 4000 lines.
How can I count the number of "Y" under one country? I
would like to be able to see the totals of "Y" for each
country.
.