help creating a Formula

I need help creating a formula for tracking Sick hours and Vacation i have  =Countif(Range,"S") - S for Sick, i need the value of S to Equal 7 and to go in the Total for Sick as well i need one for V...