Hi, I'm trying to write the formula that will count the number of rows from the sheet where only selected multiple columns (For example: Column C, F, I, L) if has number 2 to be counted. If incase any of the mentioned columns has 2, the row needs to be counted once.

The countifs and sum I m trying either gives me the row for a single row or counts if any of the rows has 2. Could anyone help me with this please?

The countifs and sum I m trying either gives me the row for a single row or counts if any of the rows has 2. Could anyone help me with this please?