View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
edju edju is offline
external usenet poster
 
Posts: 24
Default =countif question

I formulate a work schedule that has people working 8, 10 & 13 hour days. I
created three cells at the bottom to calculate the number of folks who work
either 8, 10 or 13 hrs. and another cell which gives me a total of the three.
I have a slight problem with the 10 hour box. I have 3 individuals,
physicians, who are always there 10 hours so in the box for them on the
schedule I just put a "3". I need to figure out how to get the 10 HR box to
add these three to the grand total. I use the following formula for adding
up the 10 hour people: =COUNTIF(A1:A35,10). Is there anyway to make the "3"
that I have in a cell for physicians translate to 3 more staff in the "10 HR'
totaled cell?

Thanks for any help!