A Pivot table will do what you want very quickly. With the columns labelled
Dates and Sites drag Dates into the ROW of the Pivot table and Dates in the
COLUMN and also the Data area but double click on it if it says "Sum of
Dates" and select Count.

Alternatively, use a SUMPRODUCT() formual like:

=SUMPRODUCT((Sheet2!B1:B47="A")*(Sheet2!A1:A47=200 7))

But this may be slow with a large amount of data.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Freddy" wrote in message
...
I have a spreadsheet with a 450 rows and 2 columns

The first column is a list of sites and the second is a list dates
(2003-2007).

The second sheet is a summarised table of the sites and I have been trying
to produce a vlookup function that will also count how many times the
dates
appear for those sites .

Does anyone know how to get the vlookup to count all the dates rather than
just display the first date it comes to.

I am trying to do this for 4 columns - 2003-2007

Thanks very much,
Freddy