I have a yearly vacation planner that tracks vacations (V), sick days (S),
emergency days (E).
The planner has 31 columns labelled 1 to 31 for 31 days in the month and 12
rows for 12 months of the year (Jan to Dec). If a person takes a sick day I
enter the following in the appropriated month/day cell.: 'S.5' where S
signifies it is a sick day and .5 signifies the half the day was taken as
sick day.
I would like to add all the sick days taken, or vacation days or total the
emergency days taken for the year.

Is there any way where I could truncate the first letter for each occurence
of the same type and then add the numbers after the letter for all occurences
of the same type i.e.'S'. I know another way around it is to add another
column to each day column to put in what type of day was taken and then use
the conditional sum but I was hoping to keep the spreadsheet to a minimum
number of columns. Can you help?