I have a sheet that is populated by another sheet. And in this populated sheet - I'd like to count how many times certain criteria show up (two specific data points).
I assume I would need to join the two columns (i.e., Last Name and ID) and then if these two items show up together again, I'd like to have a count of these matches.
I've tried, JOIN, COUNTIF, MATCH, but haven't been successful. The highlighted cells would be the result.
Help Article Resources
Check out the Formula Handbook template!