=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