Hi All,
I am trying to count unique values with multiple criteria.
I used below Formula but I am getting #Value
{=SUM(--(FREQUENCY(IF(AND(B18:B23=D17,A18:A23=C17),C18:C23),C18:C23)>0))}
the table I am using for this example similar to below, once it is working will apply it to a much bigger table
Date color value
1-Jun Red 11
1-Jun Red 22
1-Jun Red 11
1-Jun Blue 11
2-Jun Red 22
2-Jun Red 22
2-Jun Blue 22
2-Jun Blue 22
Bookmarks