SUMIF will be one way ..
Assume your source data as posted in Sheet1,
where col B = job numbers, col C = hours worked
Use a new/another sheet for the summary
In this new/other sheet,
With job numbers (eg: 2167, 2000, etc) running in A2 down,
put in B2: =SUMIF(Sheet1!B:B,A2,Sheet1!C:C)
Copy down to return total hours worked for the corresponding job numbers
voila? hit the YES below
--
Max
Singapore
---
"janey" wrote:
I have a worksheet set up as a monthly record of hours worked:
Example
Date Job No. Hours worked
01/02 2167 4
2000 2.5
2412 1.5
(total C1:C3) 8

This runs throughout the month; each day is calculated and the summary of
the hours worked appears at the end, using (9,C4:Cn), e.g 160.

On the next page of the same worksheet, I need the total of hours worked
during the month for each job, e.g:

Job No. Hours
2000 22
2167 14
2412 2
etc ...
Total .....160

Is there a way to calculate/add up all the hours worked during the month for
each job to enter on Page 2 rather than, as I do now, going through each day
and writing down each job and the hours worked on it.