Hi

I need to get the number of entries (of a certain type) based on
date & staff name

The data is presented as
a. Dates (All dates in column 'a' in a row)
b. Staff Name (Matthew) which is chosen through a drop down
(both a & b one one worksheet.)

another worksheet has the actual data sorted by date,time,staff name,
activity (which i need to lookup)

The cell adjacent to the date cell shouold pull up the no of records based
on the staff name chosen.

I hope I've been clear enuf on the question.
Any help apreciated.
Thx, Matt