| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count all Z in a Range
I know this function will work on a specific cell:
=LEN(A1)-LEN(SUBSTITUTE(A1,"Z","")) What about counting all letters Z in range A1:A10? Seems simple. I tried a few things; nothing has worked yet... Thanks, Ryan-- -- RyGuy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA help Range Count | Excel Discussion (Misc queries) | |||
| Using a count in a range name | Excel Discussion (Misc queries) | |||
| Sum or Count using set range | Excel Worksheet Functions | |||
| How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Threaded Mode
