Hi! So I am working in Excel and need to come up with a formula that says "in how many events did the US win a medal?" On a separate sheet, it shows the event name and which countries won bronze, silver, and gold. However, I only care about counting the event if US just won a medal, rather than double counting the US if they won two medals. Thanks!
Solved by O. Y. in 30 mins