using =COUNTIF to count two text values

  • Thread starter Thread starter John in Surrey
  • Start date Start date
J

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
 
John

One way, maybe:

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

Regards

Trevor
 
Back
Top