I'm working an an attendance sheet, so for instance I have this:

Vacation Personal Sick 1/1/06 1/2/06 1/3/06 1/4/06 1/7/06 1/8/06
0 0 0 S V
P

How can I create a formula so the when I type in S for sick day it'll equal
1 under the sick days column, etc.