Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a range of cells with values that are 5 or 10 numbers long that start
with 11, 12 or 13. What function do I use to tell Excel to count only the cells which value starts with 11? I do not want to sum, only count the number of cells that have values starting with 11. Again, the values can be 5 digits, as in 11222 or 10 digits such as 1122222222. I only want Excel to return the number of values that start with 11 regardless of how long the digit actually is. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
count even-numbered values in a range | Excel Discussion (Misc queries) | |||
how do i count cells with values in a certain range ? | Excel Discussion (Misc queries) | |||
Count the how many different values in a range | Excel Worksheet Functions | |||
How to count a range of values in a single cell? | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions |