Forum Discussion
Sumifs unique text
Hi, I have used a sumifs formula to count the number of colours for a given date - formula and results in blue. I now want to count the unique number of candidates per colour for a given date...
Depends on your version of Excel, as variant
=COUNTA(UNIQUE(FILTER($C$2:$C$10,($B$2:$B$10=G3)*($D$2:$D$10=H3))))