what does your data look like?

--
---
HTH

Bob

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



"bamboozled" wrote in message
...
Is there any way to add up the number of people assigned to a specific
area
on a rota AND at a specific time, so for example if on the rota I have 3
staff down to work on tills before 5pm and 6 staff on tills after 5pm, is
there a way excel could count through a range of cells and then display in
two seperate cells the number of staff rota'd on to tills before 5 and
after
5?