Sumifs unique text

Regular Visitor



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.





1 Reply


Depends on your version of Excel, as variant