Jyggalag
Active Member
- Joined
- Mar 8, 2021
- Messages
- 445
- Office Version
- 365
- 2019
- Platform
- Windows
I have a sheet called "Number of bank accounts". Here, in row 5, I have listed "Denmark" in cell C8, "Sweden" in cell C5, "Norway" in cell D8 and so on. In the respective cells underneath this, I want to have a formula that can take the name of the cell above it and look up the country above it (Denmark in the case of cell B9) in column E:E in my other sheet, which is called "Bank Accounts". I would like for this formula to count how many times Denmark, Sweden or any of the other countries appear in column E in the sheet Bank Accounts. However, I want to it to this based on the condition that the respective value in Column L in the sheet "Bank Accounts", for the country name in column E, contains a numeric value. If it does not contain a numeric value, or if the cell value is blank, I want the formula to ignore it and not count it I use ; as a separator, so please keep this in mind.
can anybody crack this code?
can anybody crack this code?