summarising a list of job numbers for a timesheet

[tab hunter]

is there a formula which will pick out the job number once only from the top of a timesheet to show on a summary at the bottom of a page so that I can use the dsum function to add up the hours against that job.

Daily
job no. hours
20 1.5
30 3.5
40 3.5
20 2.5

Summary
20 4.0
30 3.5
40 3.5

 

[Anne Troy]

=SUMIF(A2:A6,"20",B2:B6)

Dunno if you need the quotes or not.