Good morning all -

I am working on a spreadsheet and have extracted data from an ODBC database and need your assistance with a formula.

I have in column L, certain codes as they apply to public safety responses. Codes such as 5150, 01A01, 17A02, 25A01, 04B01, etc.

I need to count these codes in the following manor: All 5150 & 25A01 & 25A02 together, All remaining codes with 'A', and then all 'B' codes together.

Can you please help and tell me the best way to accomplish this? My knowledge is in Crystal and not so much Excel. Thank you in advance.