| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I count occurences of data entered in a column??
Try: =Countif("A:A","Yes") =Countif("A:A","No") =Countif("A:A","Yes")+Countif("A:A","No") ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count text occurences in range when criteria in other column is me | Excel Worksheet Functions | |||
| How do I count the # of unique occurences of a text in a column? | Excel Worksheet Functions | |||
| count text occurences in a column | Excel Discussion (Misc queries) | |||
| formulae to look at 52 sheets &count if 2 cells have data entered | Excel Discussion (Misc queries) | |||
| Count number of occurences in 1 column only if something in anothe | Excel Worksheet Functions | |||
![gocush[_20_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
