# Counting Jobs WEEKLY??

#### tenbobtim

##### New Member
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

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

#### agihcam

##### Well-known Member
what is the reference date column? date passed or date completed?

Date Complete

#### agihcam

##### Well-known Member
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
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

##### MrExcel MVP
Try

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

Replies
3
Views
52
Replies
0
Views
79
Replies
1
Views
96
Replies
28
Views
197
Replies
2
Views
75