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!!!

Welcome to the forum!

One method would be to use a helper column. Then count the number of Trues.

=IF(AND(LEN(A2)>=3,VALUE(RIGHT(A2,3))>=1,VALUE(RIG HT(A2,3))<=2),TRUE,FALSE)

I probably should have stated that I would need this to cover a range of cells, such as ($R$2:$R$5000). Is that possible? I tried using a countif statement, but that didn't do it.

Kenneth Hobson, I believe I have figured out what you meant, and it works perfectly!! Thank you, VERY MUCH!!!

Without helper column:

=SUMPRODUCT(--(RIGHT($R$2:$R$5000,3)={"001","002"}))

Debaser, Thanks!! This works perfectly, without having to rely on the Helper column. That one worked, but this does seem to be more efficient!!

Thanks Again!!