summing a partial cell with a specified text in the same row

Good morning everyone. Is it possible to sum a cell that contains alphanumeric? What I was trying to do is, if a cell contains the letter "S" for sick leave with a number of hours, for instance S-3, on one of the cell, and another cell S-2 in that same row range, then sum it on a specific cell as 5.

I plan on doing this for different types of leave such as V for vacation, C for credit hours, etc.. but with the same concept.

But numeric is the counts of hours, so if there for instance. S-2.5 hour, then I want the sum to consider the sum to the hour. say for example. S-2.5 in cell one, S-4.75 in cell two, then the sum should be 7.25..

yes it is, see this link and see if that will help you...
https://www.excelforum.com/excel-gen...fter-text.html

good, check posts 7 and 11 for formulas that work, you can adjust them as necessary.

Hey Sambo, it does work! However, Why do we have to double click the cell, then do the Control+Shift+Enter? how do I override this to be automatic. Maybe by pressing a macro button?

Oh I got it. Never mind. I see now it is automatic. so whenever it is created, you have to activate it. Got it!

One more question lets say there is another I want to add two different codes together "CRU" and "CRE", how do I replace them in the formula?

Thanks!