Here's what I'm trying to do. I have a spreadsheet which contains the serial numbers, asset IDs, and other information for the radios we have in our inventory. I currently use this sheet to populate other sheets automatically when a serial number is entered. This sheet contains multiple models of radios and I'm looking for a way to count how many of each radio we have without having to do it manually. The format for these serial numbers is 123ABC4567. The first 3 numbers are the same for each specific model of radio. For example, if I see a serial number of 205CDY3245, I know it is a XTS2500 portable but if the number is 527CMM4838, I know it is an APX6500 mobile. There are around 20 different models that we have.
Basically, I want to have a formula that tells me I have x number of XTS2500s, x number of APX6500s, etc.... I know I can do this by creating a column for each model type and putting a 1 in for that specific model, but that is time consuming and a mistake could easily be made. I don't know enough about formulas to figure out how to look at just the first 3 digits of the serial number and count those that match what I'm looking for. (i.e. looking for XTS2500s that start with 205XXX#### and count just those.)
Any help would be greatly appreciated. Thanks in advance.
Wayne
Bookmarks