| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF Function
Using Excel 2002
I have rows of data with values in cells. I would like to count the number of times the letter X appears in each column. Using the COUNTIF function in the following manner reports a value of zero. The formula is in cell B22: =COUNTIF(B2:B21,"X"). In column B there are ten instances of the letter X. Can someone help? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of the COUNTIF function | Excel Worksheet Functions | |||
| please help how to combine IF function with Countif function | Excel Worksheet Functions | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| Embed a countif function in subtotal function? | Excel Worksheet Functions | |||
| help with the countif function!! | Excel Worksheet Functions | |||
Threaded Mode
