|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
09-17-2007, 03:06 PM
|
|||
|
|||
|
count letters as numbers
hi there, I have a s/sheet for tracking holidays and I would like to track sick days too. I want to put an S for sick day. I think there is a way to make the s=1 then count up any s that may be in that column.
I would be so pleased if someone can get back to me as I have tried everything. thanks loads Angie, from Scotland  
|
|
#2
09-17-2007, 03:08 PM
|
||||
|
||||
|
Try something like:
=Countif(A:A,"S") where A is the column of interest. You can replace A:A with a definite range, like A1:A100, if desired.
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#3
03-21-2008, 01:19 AM
|
|||
|
|||
|
the first formula counts all the completed items, the second part counts all the items in column A. It then deducts 8 for the 8 total averages.
i would like to know how i can create a formula that will pick up all the items that have the "total averages" automatically without me having to change it manually. Every time I add lines and new total averages are created I have to change it manually. I would love for the formula to pick up the cells with the total averages only please................... there is a complete row.....A12, B12,C12, D13 all are the total averges..exp..... =COUNTIF(B13:B2071,"Completed")/(COUNTA(C13:C406)-8) i tried this one on the bottom and it gave me a total of 4 not 8? why??? there are 8 cells with the total avg. please help... =COUNTIF(A1:A209,"Totals/Avg") thank you, cathy cathy_andujar@yahoo.com
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
