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