Count IF

[Steve Kay]

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.

 

[Frank Kabel]

Hi
I'd use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm

 

[Guest]

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.

 

[Dave R.]

try this;

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

 

[Frank Kabel]

Hi
the use SUMPRODUCT. e.g.
=SUMPRODUCT(--(A1:A100="country_1"),--(B1:B100="Y"))

 

[Bob Phillips]

The country of Africa?