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"))

Quick