=SUMPRODUCT(COUNTIF(B:B,{"E","F","G"}))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"John in Wembley" wrote in message
...

Hi
I have a roster at work and use DCOUNTA to count how may qualified
nurses I have on each shift. I need to count the nurses with grade
E,F,G present on that shift
Am I correct in using Dcounta, is there any other option.
I just ask as I need to do quite a bit of work to create all the
querries for each day of the month

cheers
John