Awesome!! this really work. Thanks a lot !!

"T. Valko" wrote:

Try this:

Sheet2 A2 = 501350

=SUMIF(Sheet1!A$2:A$6,A$2,Sheet1!B$2:B$6)

Biff

"Jerry (the latin men)" <Jerry (the latin
wrote in message ...
Please some one!! help!!
I have been trying to solve this problem for couple of days, but not luck.
Here is my question! I really hope someone can help me.
I have a table with a job ID and working hours. Ex.

Column "A" (jobs)
501350
500854
513501
254789
501350


Column "B" (working hours)
4
3
5
7
4

I have on another worksheet a list of all my current jobs without any time
(work hours). I know how to use a vlookup formula to identify a job and
return a specific value, but I need a combination of two formulas (maybe
the
vlookup and other) or a new formula to add the working hours of a specific
job in my second worksheet.

For example, if I have on column "A" of my second worksheet the job #
501350. I need a formula to look for this specific job# and add (sum) the
working hours on all of them. In this example, it should be a value of
"8". I
need this value on column "B" next to the job on my second worksheet.
Which
is 4 + 4 on job# 501350 of my first worksheet.

Thanks a bunch!!