Trying to count the number of cells ending with 001 or 002
Could someone please help me? I have a column in my spreadsheet that has all numbers in it, varying from 1 to six digits. I am trying to write a formula that will count how many end with either 001, or 002. However, every time I try that, the zeroes get deleted, which won't work. These numbers have to do with mileage on automobiles. I also tried using "001" and "002", but it tells me I have a bad value. Any help would be appreciated.
Thanks!!!
|