COUNT DISTINCT Using Dates
I'm trying to count how many days in a set of data based on criteria of other columns, yet it's returning an answer for the entire sheet instead of the selected IF range.
I've tried =COUNT(DISTINCT(Date:Date), IF([Year / Month]:[Year / Month] = [Date Field for Klipfolio]@row))
My aim is count unique dates from "Date" column, when "Year / Month" column = "[Date Field for Klipfolio]2541". So as example in the screenshot the formula should return 5.
Please advise what I'm doing wrong with my formula.
Help Article Resources
Check out the Formula Handbook template!