View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bamboozled bamboozled is offline
external usenet poster
 
Posts: 5
Default adding up number of people present at certain times

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?