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
|