Count unique value with a formula in an excel report

I can use the conditional formatting to highlight duplicate values but to count only unique values meaning excluding the duplicate, I need a formula, especially when I need to include some additional criterias.



When I use the formula ?

To know how much of unique values based or not with more criterias.


How to use the formula ?

The formula in this topic is with ";" so depending of the operating system of your PC, the formula should have "," instead of ";". For the formula to work, except for the column E “total”, press “CRTL + SHIFT + ENTER” to put it between bracket {…}..


How are the formulas ?








Put this formula (for instance cell E2):


1 criteria (for instance in cell F2)


2 criterias (for instance in cells G2 and H2)


If there are blank cells, put this one (for instance cell E3):



1 criteria (for instance in cell F3)


2 criterias (for instance in cells G3 and H3)


Interesting Management