Setting Up A formula For A Time Sheet

[Guest]

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

 

[Bob Phillips]

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

--

HTH

Bob Phillips

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

 

[Guest]

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]

What do you mean exactly?

--

HTH

Bob Phillips

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

 

[Guest]

Bob

It's OK, I sorted it

Thanks anyway

Michael