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!

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-

"edju" wrote:

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!

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

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!

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!

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

"Bob Phillips" wrote:

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!