=countif question

[edju]

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!

 

[Nikki]

Assuming the cell for Phys. Hrs is B1 you can use this:
=COUNTIF(A1:A35,10)+B1

or if you need it as text:

=(COUNTIF(A15:A19,10))&" EE & " & B1&" staff"

If this is not what you need please provide more detail...
Thanks-

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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

 

[edju]

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]

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]

Ah, yes but there is beauty in simplicity! It worked. Thanks so much.