Jan 06 2021 08:23 AM
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 - results in yellow?
Any help would be much appreciated - attached.
Thanks,
Richard
Jan 06 2021 08:33 AM
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))))