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
 

Some videos you may like

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

Watch MrExcel Video

Forum statistics

Threads
1,114,406
Messages
5,547,759
Members
410,811
Latest member
adustin42
Top