how can i make a letter equal 1?
 

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.

how can i make a letter equal 1?
 

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.

how can i make a letter equal 1?
 

You could use the COUNTIF Funcion.

=COUNTIF(range,"S")

HTH,
Elkar

"Dani" wrote:

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.

how can i make a letter equal 1?
 

Thanks a bunch!

"Chip Pearson" wrote:

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.