Try something like this:

sites = range of websites
dates = range of dates

=SUMPRODUCT(--(sites=$A2),--(dates=B$1))

Copy across then down

--
Biff
Microsoft Excel MVP


"tim2216" wrote in message
...
I have a colum of dates and a colum of websites. What I am trying to do is
lookup
the date and if the date matches. It would then lookup the the webiste and
return the of times it sees the matching date and website to a seperate
sheet
under that date:

10/15/07 10/16/07
Monster 4 0
Careerbuilder 6 3

The above is what is what I am trying to.