Counting Jobs WEEKLY??

tenbobtim

New Member
Joined
Oct 12, 2006
Messages
6
We have a spreadsheet that works out Jobs the layout is as below:


Actuall Days| Date Passed| Date Complete| Job Number| Location| DWG Number| Description Of Works| Comments | Cost |





On a seperate worksheet we have want it to be able to total all the amount of Jobs we do on a WEEKLY basis .. e.g...

In the Description of works column we put down every job that we do .. and we want it to count these up and total it up PER WEEK ..(This sheet is currently working MONTHLY .. but we want it to break it down into weeks).

Any Ideas??


Cheers
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
what is the reference date column? date passed or date completed?
 

agihcam

Well-known Member
Joined
Jan 16, 2006
Messages
1,624
from an extra column you can type;
=weeknum("d2") 'for example then copy down. from there you can see different weeknumber then you can count of it.
 

tenbobtim

New Member
Joined
Oct 12, 2006
Messages
6
Sorry this may sound stupid .. but what exactly do you mean?? .. will that mean the sheet will work it out on a weekly basis for me?? without me having to use a formula each week? im already using:

=AVERAGE(IF(ABS(F5-'Wakefield PFI'!E$11:E$1024+3)<=3,'Wakefield PFI'!B$11:B$1024))

to work out the average days per week .. Column E is Complete Date and column B is total days.

Is there any way of making this so it can automatically work out the Jobs done per week Automatically??

Cheers
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,129
Messages
5,857,537
Members
431,884
Latest member
Gcmoore63

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top