#1
|
|||
|
|||
Countif returns 0 value
I have a range of numbers in a column (example below)
I tried =COUNTIF(A2:A9,"120????") and it returned a zero result, I want to count how many cell value starts with 120 1202616 1201925 805230 630154 1103057 1202559 1156971 1201577 1163681 thanks |
#2
|
|||
|
|||
Try
=SUMPRODUCT(--(--(LEFT(A2:A10,3))=120)) |
#3
|
|||
|
|||
Thanks xor, tried it nothing happened but "#value!" error...
|
#4
|
|||
|
|||
Take a look here.
|
#5
|
|||
|
|||
thanks xor, it seems the values in each cells were not recognized by the formula somehow, I manually entered the numbers and the formula works just fine....
thanks much... Jan |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to release hard returns? | markg2 | Word | 13 | 05-08-2023 01:38 PM |
Formula returns wrong value | bobsone1 | Excel | 2 | 08-19-2014 12:12 AM |
Selection.InlineShapes(1).ScaleHeight returns '0' | NobodysPerfect | Word VBA | 1 | 06-29-2014 03:59 PM |
No tabbing, no returns in forms? | rdowney1 | Word | 7 | 06-29-2012 08:35 AM |
IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |