Dav

Thank you. Unfortunately, my works internet does not permit me to view the
attachment, but will view it on another PC later on today.

Many thanks for your help. It is much appreciated.

Ellie

"Dav" wrote:


I have created a solution in the attached zipped spreadsheet. It would
be harder to explain to you in this forum

I have created 2 columns to recode the Haulier and the responsibility
data on your sheet1 using a vlookup function

I have then used a sumproduct funtion to create your counts in the
summary table

I have given you 2 ways of doing the summary based on date or
weeknumber

To use date your dates need to be formated as dates on sheet1

Regards

Dav


+-------------------------------------------------------------------+
|Filename: TestHaulier.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4987 |
+-------------------------------------------------------------------+

--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558390