Count IF
 

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.

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve Kay" schrieb im
Newsbeitrag ...
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.

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.
.

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.
.

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

--
Regards
Frank Kabel
Frankfurt, Germany

schrieb im Newsbeitrag
...
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.
.

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.
.