View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
John in Wembley John in Wembley is offline
external usenet poster
 
Posts: 26
Default Dcounta for counting staff grades

On Mon, 19 Nov 2007 18:50:18 GMT, John in Wembley
wrote:

On Sun, 18 Nov 2007 12:28:30 -0800 (PST), Pete_UK
wrote:

describing what you have and what you want to do if you require more
assistance.


staff grade mon tue wed
john A s s off
steve B off s s
anne C s s s

qualified one two one
(a,b grades)
total staff two three two

I need to count how many qualified staff on each shift...
eg Monday has one on shift., tue, two, wed, one