=SUMPRODUCT(--(Sheet1!A2:A100=501350),Sheet1!B2:B100)

adjust to suit. (you can not use whole column ex. A:A or B:B)


"Jerry (the latin men)" wrote:

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!!