Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF function bug?
Hello, i am having trouble with the countif function. I need to count the
cells which begin with a certain numeric phrase. For example, i want excel to count cells that start with "13". Then i would enter the following code: =COUNTIF(A1:A10;"13*"), but it doesn`t work. It works fine with words but gets in trouble when cells contain numbers. Is it a bug or is there something wrong with the formula? Example: 213 1345 13,34 13.44 1413 It should count cells 2, 3 and 4 because they start with 13. The answer should be 3... Thank You, Raigo Tingas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
CountIf Function Question | Excel Discussion (Misc queries) | |||
CountIF Function On Linked Spreadsheet | Excel Discussion (Misc queries) | |||
can you use countif function for noncontiguous cells | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |