Count entries based on multiple columns

Punchin83

New Member
Joined
Mar 3, 2022
Messages
2
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
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
Excel Formula:
=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
Excel Formula:
=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
Excel Formula:
=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?
 
Last edited by a moderator:

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
77,695
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
How about
Excel Formula:
=COUNTIFS(Evals_March_2022[Ops Agent Assigned],[@Name],Evals_March_2022[interaction ID],"<>")
 
Solution

Punchin83

New Member
Joined
Mar 3, 2022
Messages
2
Office Version
  1. 365
  2. 2007
Platform
  1. Windows
That was far too simple that I flew right past it! It works!!!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
77,695
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback.
 

Forum statistics

Threads
1,176,035
Messages
5,901,033
Members
434,866
Latest member
nachoabasile

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top