View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 380
Default =countif question

I am struggling here, it seems too simple

=COUNTIF(A1:A35,10)+3

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"edju" wrote in message
...
All of the hours someone is scheduled to work (8, 10, 13) are listed in a
coulmn that corresponds to a specific date listed at the top of the

coulmn.
I have a row for each name of a staff person and just one row for the

three
physicians; where I enter a "3" meaning there will be three physicians on

a
given day. If someone is working 10 HRS I put a "10" in the cell. All of
the "10's" are added in a cell at the bottom of the coulmn. What I need

is
to have the three phyiscians get added to the cell where all of the tens

are
added. If I used this "COUNTIF(A1:A1:35,3) wouldn't it just count the "3"

as
1. I need the "3" to add "3" to the total. Does that make sense?

"Bob Phillips" wrote:

=COUNTIF(A1:A35,10)+COUNTIF(A1:A135,3) ???

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edju" wrote in message
...
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!