josvill2010
New Member
- Joined
- Jun 1, 2011
- Messages
- 40
- Office Version
- 365
Hi, I have a straight forward formula to count all string starting with number 7 or 2. The usual Countif works well in most of the tabs.
There is one tab for which the formula appears not not working.
When I use =countif(Range,"7*"). It brings a zero. but I can see many strings starting with number 7 and 2.
When using =sumproduct(--(left(RANGE)="7")). I get #REF!
When I count them manually, i get 24 starting with 7 and 27 starting with number 2.
Any other suggestions to change the formula?
There is one tab for which the formula appears not not working.
When I use =countif(Range,"7*"). It brings a zero. but I can see many strings starting with number 7 and 2.
When using =sumproduct(--(left(RANGE)="7")). I get #REF!
When I count them manually, i get 24 starting with 7 and 27 starting with number 2.
Any other suggestions to change the formula?