hi there.
i have a column of telephone numbers taken from a program we use which gives us a raw data.
all i am trying to do for the last 2 hours is to do a count of all cells where the number is starting with "7".
I used the formula: =COUNTIF(A1:B8,"7*")
It just keeps coming with zero as the result. Not sure whether its to do with the formatting of the cells.
PLEASE HELP!!!!
Bookmarks