Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. . |
#4
|
|||
|
|||
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. . |
#5
|
|||
|
|||
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. . |
#6
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filter and count | Excel Discussion (Misc queries) | |||
Count occurences between dates | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |