You seem to have changed your grades !

I would suggest that you put your totals in the top two rows, rather
than at the bottom, so that you don't have to keep scrolling down and
your table can grow without messing up the formulae. So, insert two
rows at the top, so that your data now starts on row 4. In C1 (above
Monday) you can enter this formula:

=SUMPRODUCT((($B$4:$B$100="A")+($B$4:$B$100="B"))* (C4:C100="s"))

to give the number qualified who are on shift (="s"), and this one in
C2:

=COUNTIF(C4:C100,"s")

which will give the total staff on shift (excluding any "off""s).

Copy these two formulae across into the other columns to cover other
days. I've assumed you may have data up to row 100 - change this
reference if you have more.

Hope this helps.

Pete


On Nov 19, 6:50 pm, 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

thanks to all