Array - Count based on 3 conditions
 

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

Array - Count based on 3 conditions
 

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