| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use of the COUNTIF function
I currently have a cell with the current definition:
=COUNTIF(E9:E200,"1000") which yeilded the number of cells that have a value greater than 1000. Now the data in this field has been changed to an alpha numeric string and I would like to change the COUNTIF to count the number of cells where the string length is equal to 4 characters. I have tried various things like: COUNTIF(E9:E200,"LEN($)=4") whith no luck. Any suggestions or solutions would be appreciated. JCameron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF Function | Excel Worksheet Functions | |||
| 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 | |||
Threaded Mode
