Count entries based on multiple columns

[Punchin83]

I have 2 tables that I'm trying to make talk to each other. The first table is a list of technicians needing evaluations done. One of the columns is the name of the evaluating supervisor. The second table is the progress chart for each evaluator. I've got it set up so it will count how many evaluations are assigned to each evaluator by simply using

=COUNTIF(Evals_March_2022[Ops Agent Assigned],[@Name])

. On the first table the Interaction ID column is left blank until an eval is done and then the ID of said eval is placed in that respective cell for the technician. I'm trying to get a count of how many evaluations each evaluator has completed by counting how many rows have the correct name AND and interaction ID entered. The formula I have currently is

=COUNTIF(Evals_March_2022,AND(Evals_March_2022[Ops Agent Assigned]=[@Name],NOT(ISBLANK(Evals_March_2022[interaction ID]))))

but it just gives me a 0 on all evaluators. I tried

=COUNTIFS(Evals_March_2022[Ops Agent Assigned],[@Name],Evals_March_2022[interaction ID],ISTEXT(Evals_March_2022[interaction ID]))

but it gives me a SPILL error. This makes no sense to me. Can someone else make it work?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=COUNTIFS(Evals_March_2022[Ops Agent Assigned],[@Name],Evals_March_2022[interaction ID],"<>")

 

[Punchin83]

That was far too simple that I flew right past it! It works!!!

 

[Fluff]

You're welcome & thanks for the feedback.