Countif help

[Dazzybeeguy]

I have a spreadsheet as follows

Worksheet 1
Column A = list of dates
Column B = List of names
Assume A1 B1 are the 1st cells with the data

In Worksheet 2 I have Say column A with the same list of name and column b (B1) I want a formula that says

Look at the list of dates and count how many times the person in Worksheet 2 Cell B1 is shown prior to the date shown in Cell $C$1 (worksheet 2)

Thanks

 

[DanteAmor]

Try this formula in B1 on sheet2 and copy down:

=COUNTIFS(Sheet1!B:B,A1,Sheet1!A:A,"<"&$C$1)

 

[Dazzybeeguy]

=COUNTIFS(Sheet1!B:B,A1,Sheet1!A:A,"<"&$C$1)

Thanks, for what I thought would have been simple i couldnt get it to work.