Counts how many cells matching 2 criterias.
Just like CountColumnCells_Criteria but works for two criterias instead of one.
Beauty here is that it works alone without needing any other functions. Pure Excel/VBA
Edit 2024-11-24: Fixing issue with ActiveWorksheet found in all functions with optional workbook and worksheet names
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydevlib.com
Linkedin Login
ColumnName, Criteria, Optional Column2Name = "", Optional Criteria2 = "", Optional WB = "This", Optional Shee = "Active", Optional StartFromRow = 1
Views 758
Downloads 103
CodeID
DB ID
