software

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

VacationPersonalSick 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.

Dani,

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

=COUNTIF(A2:K2,quot;Squot;)--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Daniquot; gt; wrote in message
...
gt; I'm working an an attendance sheet, so for instance I have
gt; this:
gt;
gt; Vacation Personal Sick 1/1/06 1/2/06 1/3/06 1/4/06 1/7/06
gt; 1/8/06
gt; 0 0 0 S
gt; V
gt; P
gt;
gt; How can I create a formula so the when I type in S for sick day
gt; it'll equal
gt; 1 under the sick days column, etc.
You could use the COUNTIF Funcion.

=COUNTIF(range,quot;Squot;)

HTH,
Elkar

quot;Daniquot; wrote:

gt; I'm working an an attendance sheet, so for instance I have this:
gt;
gt; VacationPersonalSick 1/1/06 1/2/06 1/3/06 1/4/06 1/7/06 1/8/06
gt; 0 0 0 S V
gt; P
gt;
gt; How can I create a formula so the when I type in S for sick day it'll equal
gt; 1 under the sick days column, etc.

Thanks a bunch!

quot;Chip Pearsonquot; wrote:

gt; Dani,
gt;
gt; You can use the COUNTIF function to count the number of 'S'
gt; characters in your row of data. E.g.,
gt;
gt; =COUNTIF(A2:K2,quot;Squot;)
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Daniquot; gt; wrote in message
gt; ...
gt; gt; I'm working an an attendance sheet, so for instance I have
gt; gt; this:
gt; gt;
gt; gt; Vacation Personal Sick 1/1/06 1/2/06 1/3/06 1/4/06 1/7/06
gt; gt; 1/8/06
gt; gt; 0 0 0 S
gt; gt; V
gt; gt; P
gt; gt;
gt; gt; How can I create a formula so the when I type in S for sick day
gt; gt; it'll equal
gt; gt; 1 under the sick days column, etc.
gt;
gt;
gt;