ExcelBanter - using =COUNTIF to count two text values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - using =COUNTIF to count two text values (https://www.excelbanter.com/excel-worksheet-functions/52180-using-%3Dcountif-count-two-text-values.html)

John in Surrey

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

Trevor Shuttleworth

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

All times are GMT +1. The time now is 01:48 AM.