Dani,

You can use the COUNTIF function to count the number of 'S'
characters in your row of data. E.g.,

=COUNTIF(A2:K2,"S")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Dani" wrote in message
...
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.