Conditional formatting, letter, colour, number and add, in staff annual leave tracker

a sample would be useful
but to sum the different letters
you can use an array formula
Use control + Shift +enter for {} around the formula - although Excel 365 now does accepts arrays automatically

=SUM(IF(LEFT(B2:Z2,1)="S",VALUE(MID(C2:Z2,2,5))))

That assumes entry like S 2.5
and the Z change to the last column in your year list

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

HOW TO ATTACH YOUR SAMPLE WORKBOOK:
See the yellow banner at top of screen
UserName Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.