summarising a list of job numbers for a timesheet

tab hunter · Apr 29th, 2002, 12:33 PM

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 · Apr 29th, 2002, 12:36 PM

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

Dunno if you need the quotes or not.

Apr 29th, 2002, 12:36 PM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	=SUMIF(A2:A6,"20",B2:B6) Dunno if you need the quotes or not. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 29th, 2002, 12:33 PM	#1
tab hunter New Member Join Date: Apr 2002 Posts: 1	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