Count If (for 2 criteria)

[Chris Ashley]

Is there a way to use a formula to count the occurrences, in a range,
of 2 statements?

I wanted to counc to count the number of "NG" and "OUT" within the
range A1:A10.

 

[Alan Beban]

Or =SUM(COUNTIF(A1:A10,{"NG","OUT"}))

Alan Beban

 

[dave!!]

=COUNTIF(A1:A10,"NG")+COUNTIF(A1:A10,"OUT")