Cross sheet reference function

[Guest]

Hey,

I'm a newbie to use Excel. I need to come up with a workbook has 2 spread
sheets in it.
The first sheet hold the project name, Time I spent on it, Date etc. I have
several projects in one day. In the second spread sheet I need to know total
hour I spent on the projects. I do not want to hand input the hours. Is there
a formula or function I can use so the hour information in the 2nd
spreedsheet could be updated automaticallly according to the data I entered
in the 1st sheet?

Thanks in advance!
Rocky

 

[Guest]

If u have Project-names i Sheet1 column A
And Hour in Sheet1 column B (put in as times fx. 2:15)

in Sheet2 A2 copy down to row 1000

=IF(COUNTIF(Sheet1!A2:$A$1000,Sheet1!A2)=1,Sheet1!A2,"")