# 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

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
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))

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.

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.

### Which adblocker are you using?

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

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