I need to add the numbers with a label behind it. For instance in one row I
have 0.5S in Cell E9, 0.5S in Cell G9 and 0.5V in Cell J9 and 0.5V in Cell
L9. How do I get excel to know that Vacation time totals 1.0 and Sick time
total 1.0.

I can get this to calculate without the labels however, I need to differiate
sick from vacation time.

If this is not possible, do you have any other solution?