Countif Function using more than 1 criteria

[carl]

Hi. Can the CountIf function be used with more than 1
criteria.

For example. If I wanted to countif a cell contained Black
OR Blue ?

Thank you in advance.

 

[Frank Kabel]

Hi
some solutions
=COUNTIF(A1:A1000,"Black")+COUNTIF(A1:A1000,"Blue")

or
=SUMPRODUCT((A1:A1000="Black")+(A1:A1000="Blue"))

or
=SUMPRODUCT(--(A1:A1000={"Black","Blue"}))

 

[Alan Beban]

One more:

=SUM(COUNTIF(A1:A1000,{"Black","Blue"}))

Alan Beban