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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks