| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula based on text information
hi all
I want to create a roster sheet with a formula that will return a result based on the number of absentees. I want to enter the words Holidays, Off or Sick, and have the formula calculate the number of people absent on that day. Does anyone know how to create this sort of formula based on alpha data? thanks Kathryn |
|
#2
|
|||
|
|||
|
=COUNTIF(A1:A100,"Holidays")
etc. -- HTH RP (remove nothere from the email address if mailing direct) "Kathryn W" wrote in message ... hi all I want to create a roster sheet with a formula that will return a result based on the number of absentees. I want to enter the words Holidays, Off or Sick, and have the formula calculate the number of people absent on that day. Does anyone know how to create this sort of formula based on alpha data? thanks Kathryn |
|
#3
|
|||
|
|||
|
thanks for that
cheers "Bob Phillips" wrote: =COUNTIF(A1:A100,"Holidays") etc. -- HTH RP (remove nothere from the email address if mailing direct) "Kathryn W" wrote in message ... hi all I want to create a roster sheet with a formula that will return a result based on the number of absentees. I want to enter the words Holidays, Off or Sick, and have the formula calculate the number of people absent on that day. Does anyone know how to create this sort of formula based on alpha data? thanks Kathryn |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text in formula explaining formula not to print | Excel Worksheet Functions | |||
| Can I create and save a formula for text fields? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Summing an array based on text condition | Excel Discussion (Misc queries) | |||
| need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
Linear Mode
