Counting across multiple tabs with multiple criteria

[Tim0705]

I am creating a summary table to looks for multiple criteria to be met across different columns in different tabs. Which is the best way of doing this?

What i have is as follows:

SHEET 1

SHEET 2

In Sheet 1 Cell C2 i need it to count the number of cells in Sheet 2 Column D that equal the following 3 criteria:
1. A2
2. B2
3. Greater than or equal to 100

With the data provided this should equal 2 masters in roster A, 1 master in roster B.

What formula is best to use for this purpose?

 

[Fluff]

How about

=COUNTIFS(Sheet2!D:D,">=100",Sheet2!B:B,A2,Sheet2!C:C,B2)

 

[Tim0705]

That's great......i tried something so similar but it did not work so this is great help.

 

[Fluff]

You're welcome & thanks for the feedback.