Counting occurrences of a string in a row

Nick0000

I am trying to count the number of times "N/A" is included in a single row. I know it can been done with a single range with the below equation, but in this sheet there are some columns that want to exclude. Is it possible to get a count of the "N/A"s in the sheet with multiple ranges to exclude some rows?

=COUNTIF([Column 1]@row:[Column 10]@row, CONTAINS("N/A", @cell))

Paul Newcome

You would write out separate COUNTIFS and then add them together.

Paul Newcome

You would write out separate COUNTIFS and then add them together.

Leroy Noriega

You can create a checkbox column named, 'Exclude from N/A Count'. Those that need to be excluded you can check the box. With your current formula you can add the IF formula to look at the 'Exclude from N/A Count' column, if its true then don't count, If not then count.

Paul Newcome

@Leroy Noriega How would you propose implementing this when the range is a single row and specific columns need to be excluded?