trying to do countif using index match

Hi in the attatched workbook in the Roster tab in column C I am trying to count how many times a name shows up in column F of the safety contact tab between two dates tab. but I have never used index match so I am really lost.

I don't think you need index match.

See the attached.

then how would I do it? I am very lost on how to pull this data.

I attached a copy of it with the formula that I think does what you want. It's simply a countif formula.

I also need it to look between two dates.

Where are the two dates to which you are referring?

I haven't added them yet. but they should be in M1 and N1

Just add two more criteria to COUNTIFS

an example ....

=COUNTIFS(F:F, criteria1, G:G,">=" & M1, G:G, "<=" & N1)

G:G is date column with Excel dates (not text)

M1 = Start date

N1=End Date