hello
i want to caunt unique values from a array (column c) but only where column F have the value "z569pon" and column G have the value "startet"
this formula count all uinque from the array =SUM(IF(FREQUENCY(B3:B2000;B3:B2000)>0;1))
and this =COUNTIFS(F3:F2000;"z569pon";G3:G2000;"startet") count all not the only the unique
is it possiblie to combine thise to formula?
Bookmarks