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

I'm not sure what the three conditions are that you have in your
heading, but you can count the two like this:

=SUMPRODUCT((Sheet2!A1:A100=A1)*(Sheet2!B1:B100=B1 ))

Assumes that your main data is on Sheet2, occupying up to 100 rows,
and that your drop-downs are in A1 and B1 (in future, please be
specific about the cells, ranges and sheetnames that you are using).

Hope this helps.

Pete

On Sep 1, 5:08*pm, Matts wrote:
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