Hello,

I would like to enter in a cell S (sick) or V (vacation) and when refer to that cell that it is considered as 0.

As for now, When someone is sick or on vacation, I only put a 0 in the cell but by entering the "S" or "V" I could distinguis the vacation form the sickness.

would you then know how to associate formulas with letter that woudl be consider as 0? and could I do a Sum of all S and V in my excel??

Thanks,
G