how can i make a letter equal 1?

[Dani]

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.

 

[Chip Pearson]

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

 

[Elkar]

You could use the COUNTIF Funcion.

=COUNTIF(range,"S")

HTH,
Elkar

 

[Dani]

Thanks a bunch!

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