Forum Discussion
Karolis D
Mar 02, 2018Copper Contributor
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.
3 Replies
- SergeiBaklanDiamond Contributor
- kelvinwbruceCopper Contributor
=countifs(E:E,"*"&"Italija"&"*",F:F,"saus")
- Detlef_LewinSilver Contributor