Array - Count based on 3 conditions

M

Matts

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
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top