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