problem counting number with letter in formula

I am making a formula where criteria varies as to what the end number is. I'm using the formula below and it works well when I use: number, *, or all letters like "ADM." It does not work when the criteria is: 7C, 19C, or 7a, 7s. You get what I mean. I need to have the criteria of: 7C=12.5. I'm adding up number of hours worked on a shift. Anyone with suggestions?




=COUNTIF(P6:P41,"7")*1+COUNTIF(P6:P41,"7*")*1+COUNTIF(P6:P41,"8")*1+COUNTIF(P6:P41,"8*")*1+ COUNTIF(P6:P41,"9")*1+COUNTIF(P6:P41,"9*")*1+COUNTIF(P6:P41,"11")*1+COUNTIF(P6:P41,"11*")*1

Tony, Thank-you for the reply. I inherited a schedule when I became manager and want to see if I can work with it before I make changes (I'v already made a lot of changes). The previous manager did all the scheduling of staff on paper but it needs to be done on a shared drive so all the managers have access to it. They are using numbers and letters entered in cells to represent certain shifts: for 7 cells in a row (1 week work) we may enter: 7 (12.25hrs), 7*(12.25hrs), 7C (12.25hrs), 7a (10hrs), 7s (8hrs), LV8 (8hr), LV12 (12hrs). There are other combinations but this is the idea.

At the end of the 7 cells (1 week) is a cell with the formula below. This represents the total number of hrs worked for the week. The cells with the number/letter combination don't add correctly consistently.

=COUNTIF(AG5:AT5,"7")*12.25+COUNTIF(AG5:AT5,"7*")*12.25+
COUNTIF(AG5:AT5,"ADMS")*8+COUNTIF(AG5:AT5,"ADM")*10+
COUNTIF(AG5:AT5,"9")*12+COUNTIF(AG5:AT5,"9*")*12+
COUNTIF(AG5:AT5,"11")*12+COUNTIF(AG5:AT5,"11*")*12+
COUNTIF(AG5:AT5,"19")*12.25+COUNTIF(AG5:AT5,"19*")*12.25+
COUNTIF(AG5:AT5,"23")*8+COUNTIF(AG5:AT5,"LV8")*8+
COUNTIF(AG5:AT5,"LVL")*12+COUNTIF(AG5:AT5,"BLS")*8+
COUNTIF(AG5:AT5,"ACLS")*8+COUNTIF(AG5:AT5,"PALS")*8+
COUNTIF(AG5:AT5,"SED")*4+COUNTIF(AG5:AT5,"H")*8+
COUNTIF(AG5:AT5,"R")*0+COUNTIF(AG5:AT5,"D")*0+
COUNTIF(AG5:AT5,"PASS")*8+COUNTIF(AG5:AT5,"TDY")*8

Thank-you for looking at this.