Forum Discussion

Karolis D's avatar
Karolis D
Copper Contributor
Mar 02, 2018

COUNTIFS distinct

Hello, 

 

please help me find a solution:

I need to count the number of distinct text and number values in column $M:$M , when in column $E:$E is written "*italija*", and when in column $F:$F is written "saus", also - it should not count blank cells.

 

Now I am doing this in pivot: filtering column F with "saus", than filtering column E with "italija", than copying column M in another sheet, removing dublicates and counting the cells.

Resources