Hello, suppose the following: I have a list of various departments. I want to count how many times each department shows up in a list. However, I am also only looking for it to be counted if another separate column doesn't have an 'x' in it.
What formula could I use for that? Example below:
A x
B
C
D x
A
B
C x
D
C
B
A x
A 1
B 3
C 2
D 1
What formula could I use for that? Example below:
A x
B
C
D x
A
B
C x
D
C
B
A x
A 1
B 3
C 2
D 1