Counting the number of times someone called in sick

S

smskater

How do I count the number of times a person has called in sick?

9/1/05 work
9/2/05 work
9/3/05 sick
9/4/05 sick
9/5/05 work
9/6/05 sick

The above example shows the person called in sick 2 times for 3 days.
How do I create a formula that reflects this?

thanks
 
C

Chip Pearson

Use the COUNTIF function. Something like

=COUNTIF(B1:B100,"sick")


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

Dave Peterson

If you have something in those cells (and it looks like you do), you can use:

=counta(b1:b100)
 
Top