That is what my formulae do. Did you try them?

Pete

On Nov 19, 7:35 pm, John in Wembley wrote:
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