| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
