BlueRuby001
New Member
- Joined
- Mar 24, 2022
- Messages
- 9
- Office Version
- 2013
- Platform
- Windows
Wracking brain for two days on this.
Have two tables and trying to count how many in table 1 column A match table 2 column A and of those in table 1 that have matches, how many of those have the value "Y" in table 2 column B.
Tried variations of countifs with match, sumproduct etc with no luck so far and im sure i missed something stupidly simple.
Help is greatly appreciated.
Have two tables and trying to count how many in table 1 column A match table 2 column A and of those in table 1 that have matches, how many of those have the value "Y" in table 2 column B.
Tried variations of countifs with match, sumproduct etc with no luck so far and im sure i missed something stupidly simple.
Help is greatly appreciated.