How to apply multiple condition in same column in excel -
Here I want to apply muptialial status to the same column but using counting is not getting the proper output Excel value : -
column 1 column 2 y one YBYC YDN SNB
tried formula: = SM (COUNTIFS (B) Expected Output: - 2
Answer: - In addition to this, I want to "Y" in column 1 and "B", "A", "B"}))
Expected Output: Column 2 Fill with "A", "B" More output should come in the file: - 2
This function is for many categories
that is where Columns a = 'a' and column b = 'a'
can never be followed by 'a' and 'b', as a result 0
Try it instead.
= COUNTIF (A: A, "A") + (COUNTIF (A: A, "B"))
Or at the same limit Can do this for many situations.
= COUNTIFS (A: A, {"A", "B"})
but it produces 2 arrays for each condition "A" and "b" therefore need to express them.
= SUM (COUNTIFS (A: A, {"a", "b"}))
= SUM (COUNTIFS (B: B, {"A", "B"}, A: Additional conditions can be added on other columns. A, "Y"))
Comments
Post a Comment