using =COUNTIF to count two text values

[John in Surrey]

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]

John

One way, maybe:

=COUNTIF(E5:E13,"E") +COUNTIF(E5:E13,"E ot")

Regards

Trevor