Setting Up A formula For A Time Sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zooming - 20 Jun 2006 15:14 GMT

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

Reply to this Message

Bob Phillips - 20 Jun 2006 15:19 GMT

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

--

HTH

Bob Phillips

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

> 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
[quoted text clipped - 3 lines]
>
> Thanks

Reply to this Message

zooming - 26 Jun 2006 10:58 GMT

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

> =SUMIF(A:A,"Project 1",B:B)
>
[quoted text clipped - 15 lines]
> >
> > Thanks

Reply to this Message

Bob Phillips - 26 Jun 2006 17:50 GMT

What do you mean exactly?

--

HTH

Bob Phillips

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

> Bob
>
[quoted text clipped - 25 lines]
> > >
> > > Thanks

Reply to this Message

zooming - 27 Jun 2006 08:13 GMT

Bob

It's OK, I sorted it

Thanks anyway

Michael

> What do you mean exactly?
>
[quoted text clipped - 39 lines]
> > > >
> > > > Thanks

Reply to this Message