View Single Post
 
Old 07-25-2019, 03:58 PM
mgroessl mgroessl is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2019
Posts: 4
mgroessl is on a distinguished road
Default 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!!!
Reply With Quote