View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Freddy[_2_] Freddy[_2_] is offline
external usenet poster
 
Posts: 9
Default Vvlookup and count

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