| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting the number of times someone called in sick
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 |
|
#2
|
|||
|
|||
|
Use the COUNTIF function. Something like
=COUNTIF(B1:B100,"sick") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "smskater" wrote in message ups.com... 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 |
|
#3
|
|||
|
|||
|
Thanks, but this just shows the total for sick. How do I count the
occurrences? Chip Pearson wrote: Use the COUNTIF function. Something like =COUNTIF(B1:B100,"sick") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "smskater" wrote in message ups.com... 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 |
|
#4
|
|||
|
|||
|
If you have something in those cells (and it looks like you do), you can use:
=counta(b1:b100) smskater wrote: Thanks, but this just shows the total for sick. How do I count the occurrences? Chip Pearson wrote: Use the COUNTIF function. Something like =COUNTIF(B1:B100,"sick") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "smskater" wrote in message ups.com... 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting the number of printed spreadsheets | Excel Worksheet Functions | |||
| after entering certain number of times wrong password file can cur | Excel Discussion (Misc queries) | |||
| counting number of particular items in a list | Excel Discussion (Misc queries) | |||
| doubling a number X number of times | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
