Counting Jobs WEEKLY??

[tenbobtim]

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

 

[agihcam]

what is the reference date column? date passed or date completed?

 

[tenbobtim]

Date Complete

 

[agihcam]

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]

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

 

[barry houdini]

Try

=SUMPRODUCT(--(ABS(F5-'Wakefield PFI'!E$11:E$1024+3)<=3))