I have a workbook with several sheets. On the first sheet are multiple daily
entries. On other sheets are where data comes from sheet 1 into summaries
etc. My problem is that I am trying to get the total number of occurrences
of certain numbers meeting certain fields to go into 1 of 4 categories on the
summary sheet. Is this possible?

e.g.
Sheet 1 - multiple daily entries
Col A = week number
Col B = date
Col C = load no.
Col D = order no.
Col E = customer name/location
Col F = Haulier
Col G = Responsibility code

Summary sheet
e.g.
Haulier Prem Customer Other Total
NW
EA
Total

In Column F of Sheet 1 there are 3 Hauliers, namely EA = WRW and NW = KAM
and HAL. One of these will be entered against each entry per day.

In Column G of Sheet 1 is put a responsibility code. There are a total of
18 non-consecutive numbers split between Haulier, Prem, Customer and Other.
I have created ranges for each of these 4, but so far have been unsuccessful
in creating a formula that works.

Many thanks in advance.