I need my COUNTIFS formula to only count if one of the people who appears in column F is also one of the people in a range on another tab here: =Key!V2:V12.
So in this formula below, A_List_Import!$F:$F,'All Dates'!$A$501 is just looking for one person. But I need it to count it if the person matches one of the names in a range here: =Key!V2:V12
Does anyone know how to add that to my countif?
=COUNTIFS(A_List_Import!$E:$E,">="&'All Dates'!B305,A_List_Import!$E:$E,"<="&'All Dates'!B306,A_List_Import!$G:$G,'All Dates'!$A$421,A_List_Import!$L:$L,'All Dates'!$A$490,A_List_Import!$F:$F,'All Dates'!$A$501)
So in this formula below, A_List_Import!$F:$F,'All Dates'!$A$501 is just looking for one person. But I need it to count it if the person matches one of the names in a range here: =Key!V2:V12
Does anyone know how to add that to my countif?
=COUNTIFS(A_List_Import!$E:$E,">="&'All Dates'!B305,A_List_Import!$E:$E,"<="&'All Dates'!B306,A_List_Import!$G:$G,'All Dates'!$A$421,A_List_Import!$L:$L,'All Dates'!$A$490,A_List_Import!$F:$F,'All Dates'!$A$501)
