WEEK DATE LOAD DOCKET CUSTOMER HAULIER REASON CODE CASES COMMENTS
Week 37 12-Sep 81022 54171503 Asda Normanton WRW 14 2560 Failed to be
collected by Asda backhaul. To be rebooked.
12-Sep 81023 54171505 Asda Normanton WRW 14 2080 Failed to be collected by
Asda backhaul. To be rebooked.
12-Sep 80986 54171508/09 Asda Washington WRW 5 2254 Sub-contractor
collected the wrong load. To be rebooked.
12-Sep HAL 62106 85201260/63/80 Asda Grangemouth HAL 2 3481 Booking time
23:00hrs. Delayed en route. To be rebooked.
12-Sep 80985 54171538/39/40/41 Asda Lutterworth WRW 12 4914 Booking time
22:00hrs. To be rebooked.
13-Sep NO ISSUES
14-Sep HAL 62118 85201363/71/76 Asda Wigan HAL 6 2836 Vehicle broke down.
Rebooked 16/09/05 @ 19:20hrs.
14-Sep KAM 61784 85201328/29/30 Asda Lutterworth KAM 4 4741 Delays loading.
Load running approx. 1.5hrs late.
The above is a sample of the first sheet mentioned below. Hope this helps.
Thanks for letting me know about the = with the date. Wasn't sure if it was
necessary or not.
"Paul Sheppard" wrote:
I have a report over 2 separate sheets in a workbook.
On the first sheet I have my core data, covering approx. 8 columns,
inclusive of date, load number (in columns B and C) and cases (in
On the second sheet I am currently manually inputting the result of
entered into the first sheet.
The data in columns B, C and H are what I manually input into the
In this 2nd sheet I have column A with the date in the same format as
first worksheet along with column D being the total number of loads for
date and column E being the total number of cases also for that date.
Unfortunately on the first worksheet I sometimes have dates where no
available and put this in as "No Issues", but having used COUNTIF
date find that No Issues is being counted, as I obviously have entered
date into the first sheet.
e.g. of 2nd sheet in workbook:-
W/C 12/09 Total Loads Total Cases Failure Loads Failure Cases
TOTAL 0 0 0
As a sample, I had used =COUNTIF(Sheet1!B2:I6,"=12-Sep") against the
Loads for 12-Sep, which returns the correct number, but unfortunately
going for 13-Sep returned 1, even though it was No Issues, so should be
Is there any suggestion to amend the above COUNTIF calculation, to give
what I require, or something else to do this for me.
Your formula looks ok except you don't need = infront 0f 12-Sep
To help further put a sample of the data from the first sheet
As an alternative, you could just put subtotals on your Data
Subtotals at each change of date
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=467797