Setting Up A formula For A Time Sheet
 

I have setup a column with a list box that includes several project headings.
I have also setup a list box that allows you to select the amount of time you
spend on each project. The worksheet has 30 rows that will allow you to
select the project and time, what formula can I use that will allow me
calculate the time spent on each projects as a whole.

Thanks

Setting Up A formula For A Time Sheet
 

=SUMIF(A:A,"Project 1",B:B)

--

HTH

Bob Phillips

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

"zooming" wrote in message
...
I have setup a column with a list box that includes several project
headings.
I have also setup a list box that allows you to select the amount of time
you
spend on each project. The worksheet has 30 rows that will allow you to
select the project and time, what formula can I use that will allow me
calculate the time spent on each projects as a whole.

Thanks

Setting Up A formula For A Time Sheet
 

Bob

Thanks for the formula, it worked fine, however when I attempt to copty the
formula into another sheet of the workbook the formula retains the previous
sheets references. How can I resolve this?

Thanks

Michael


"Bob Phillips" wrote:

=SUMIF(A:A,"Project 1",B:B)

--

HTH

Bob Phillips

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

"zooming" wrote in message
...
I have setup a column with a list box that includes several project
headings.
I have also setup a list box that allows you to select the amount of time
you
spend on each project. The worksheet has 30 rows that will allow you to
select the project and time, what formula can I use that will allow me
calculate the time spent on each projects as a whole.

Thanks

Setting Up A formula For A Time Sheet
 

What do you mean exactly?

--

HTH

Bob Phillips

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

"zooming" wrote in message
...
Bob

Thanks for the formula, it worked fine, however when I attempt to copty
the
formula into another sheet of the workbook the formula retains the
previous
sheets references. How can I resolve this?

Thanks

Michael


"Bob Phillips" wrote:

=SUMIF(A:A,"Project 1",B:B)

--

HTH

Bob Phillips

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

"zooming" wrote in message
...
I have setup a column with a list box that includes several project
headings.
I have also setup a list box that allows you to select the amount of
time
you
spend on each project. The worksheet has 30 rows that will allow you
to
select the project and time, what formula can I use that will allow me
calculate the time spent on each projects as a whole.

Thanks

Setting Up A formula For A Time Sheet
 

Bob

It's OK, I sorted it

Thanks anyway

Michael


"Bob Phillips" wrote:

What do you mean exactly?

--

HTH

Bob Phillips

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

"zooming" wrote in message
...
Bob

Thanks for the formula, it worked fine, however when I attempt to copty
the
formula into another sheet of the workbook the formula retains the
previous
sheets references. How can I resolve this?

Thanks

Michael


"Bob Phillips" wrote:

=SUMIF(A:A,"Project 1",B:B)

--

HTH

Bob Phillips

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

"zooming" wrote in message
...
I have setup a column with a list box that includes several project
headings.
I have also setup a list box that allows you to select the amount of
time
you
spend on each project. The worksheet has 30 rows that will allow you
to
select the project and time, what formula can I use that will allow me
calculate the time spent on each projects as a whole.

Thanks