Hi all,
I need to be able to count the number of "yes" entries in a cell based on whether another cell contains a specific text. Here's my scenario:
I have a tab called raw data that contains columns called: ID#, Title, Internal, Name, Location, Unit
I want to count the number of "yes"...