Sumifs unique text

Regular Visitor

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

1 Reply

@richardcresswell 

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))))