I am trying to figure out a formula that will give me the total count of cells to match my criteria below:
Criteria:
Is the first Non-Rotational Location in the same state as the University?
If so, how many are there?
The state (spelled out completely) of each location is in the "Location" Tab
The location list will be a dynamic list.
I would like a formula that can find the state for each 1st Non-Rotational Location shown above and then see if it is the same as the "State of University" of the cell next to it.
If it is a match, it should count it and provide a sum of the total matches.
Bookmarks