bobbyexcel
Board Regular
- Joined
- Nov 21, 2019
- Messages
- 88
- Office Version
- 365
- Platform
- Windows
Need help on my below issue.. I've 3 sheets to go through multiple conditions to get the count if condition satisfies.
Here is the screenshot of the data and my requirements..
I need the results in Sheet1 based on the country of the manager.. I used the below Index formula but didn't get the results of it. Can someone help me on this.
=COUNT(INDEX('Sheet1'!$F:$F,MATCH(1,(B3='Sheet3'!$R:$R)*('Sheet3'!$Q:$Q='Sheet2'!$N:$N)*('Sheet1'!$F1='Sheet2'!$O:$O),0)))
Here is the screenshot of the data and my requirements..
I need the results in Sheet1 based on the country of the manager.. I used the below Index formula but didn't get the results of it. Can someone help me on this.
=COUNT(INDEX('Sheet1'!$F:$F,MATCH(1,(B3='Sheet3'!$R:$R)*('Sheet3'!$Q:$Q='Sheet2'!$N:$N)*('Sheet1'!$F1='Sheet2'!$O:$O),0)))