Thank you @Jeremy_Oglesby! This works to cut every bank that worked on any China-based deals. Do you know of a method to keep the banks that worked on China-based deals, but drop only those specific, China deals from the count? I’ve included a screen...

2nd screenshot. These numbers include the deals for China-based companies, which is what I’m trying to cut.

@Tuur thanks for this idea. Can you please explain in a little more detail how to do this? I’m trying to use the COUNT function to create a ranking of banks advising on tech IPOs. I’d like to filter out deals involving companies headquartered in Chin...