Just trying to learn something new. I'm pretty sure I can solve this with concat(), or creating extra columns. I can also do it with a pivot table. But I'd like to know what other options are out there.
I want to count entries in a range that contains text - not too sure if that part matters?. For example:
D2:D1000 (contains text)
I want to count the cells in that range if their value is "example_d", AND if the value in column C is "example_c, AND if the value in column B is "example_b", AND if the value in column A is....you get the idea...
So basically count the cells in that range, based on criteria for that column, as well as criteria for 3 other columns. Without using a pivot table, creating new columns, or vba (=