Not sure how to work this, but I think a previous post had me on the right track, but I'm stuck in this particular situation.
Sheet1 is raw data (material number in A:A, Created by user in D:D, username in C3). second tab (PVT) is a pivot table documenting the number of occurrences a specific material appears in Sheet1. I need to look at the material in the pivot table, find out how many times user listed in C3 is found next to that material number in Sheet 1.
=COUNTIF(Sheet1!D:D,VLOOKUP("WYGLADALB",A:A,0))
This is what I'm currently using, but obviously this isn't correct. Here is a sample spreadsheet.
Use
COUNTIFS()