I want to count the total number of distinct properties (Property column) in the HZ locations (just the ones that have the text “hz” in any part of their name in the “UWI” column) for a table of data. But I don’t seem to get the correct function to work even for this small table where I can check visually if it’s working, and I have to do this task for other tables with way more data.