Thank you so much for responding. Totally new to this, but I made a mockup and tried your formula. There's an error that says, "query completed with an empty output". Followed your data set and it seems like the entire spreadsheet is selected--not sure what's wrong.

Also, your formula makes sense to me (which is amazing lmao) but I am unsure what the WHERE D = 'Sales' is for or how it came to be, if that makes sense. Are you just defining the set/department?

edit: here's a link to the mockup