COUNTIF Formula help
Posted on 2011-05-11
Can someone please help me understand what I am doing wrong with the below formula?
I am trying to extract the first two digits from the cells in sheet 1 column G which has text like this - 15 Late.
Then I am trying to count the occurrences of the numbers greater than or equal to 15 within the specified range. However I can’t get my head around converting the 15 into a number format within the COUNTIF formula in order to actually count it.
Here is my formula :