I cannot get a “Count if” formula to work. More clear explanation in screenshot below but I will try and summarize it here as well.
I want to count the “Yes” in a column if that row also contains a specific email. But I also don’t want that count to be in a table, just in text (as you will see on screenshot).
Screenshot of what I have tried so far in terms of formulas is below: