=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!
|