| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
using =COUNTIF to count two text values
hi folks
=COUNTIF(E5:E13,"E") counts the number of staff doing an E (early shift) as entered in the column E5:E13 I need to count staff doing an "E" (early) and staff doing an " E ot" ( early shift as overtime) thanks JOhn john Images of nz (home) http:\\www.myplace.co.nz/home What we are up to in the UK http:\\www.myplace.co.nz |
|
#2
|
|||
|
|||
|
using =COUNTIF to count two text values
John
One way, maybe: =COUNTIF(E5:E13,"E") +COUNTIF(E5:E13,"E ot") Regards Trevor "John in Surrey" wrote in message ... hi folks =COUNTIF(E5:E13,"E") counts the number of staff doing an E (early shift) as entered in the column E5:E13 I need to count staff doing an "E" (early) and staff doing an " E ot" ( early shift as overtime) thanks JOhn john Images of nz (home) http:\\www.myplace.co.nz/home What we are up to in the UK http:\\www.myplace.co.nz |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Getting Count field to recognise rows with negative values in Exc. | Excel Worksheet Functions | |||
| Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
| how do I 'count' the number of cells with a text in red or black? | Excel Worksheet Functions | |||
Hybrid Mode
