Countif report with duplicates

[lbrad24]

I'll try to explain this the best as I can. I have a call log that I am keeping track of customer contacts in a table. I have a separate table counting results of those calls "NA, LM, Texted, or LM & Texted." I'm wanting to track follow ups that I receive based on those results. I assume the easiest way to count those results will have something to do with searching the table for the name with the result "quoted" to find where it was previously "NA, LM, Texted, or LM & Texted." I'm struggling with the logic though.

 

[bjuntz]

I am not fully clear on what your goal is but I think this will get you started.
Add a calculated column "Quoted" to the Activity Tracker that determines if that lines name is ever quoted. here are 2 ways (I prefer #2)
1. (as array formula) {=IFERROR(IF(MATCH(1,([Name]=[@Name])*([result]="Quoted"),0)>0,"Y","N"),"N")}
2. =IF(SUMPRODUCT(--([Name]=[@Name]),--([result]="Quoted"))>0,"Y","N")

Then in your quoted by result table use your proposed countifs
ex. for the NA column(Note Table1 would be your Activity Tracker table): =COUNTIFS(Table1[result],"NA",Table1[Quoted],"Y")
or using sumproduct, =SUMPRODUCT(--(Table1[result]="NA"),--(Table1[Quoted]="Y"))
Then substitute in the needed conditions for each column.