Can you do an "or" for countifs?

[ammartino44]

Hello. Can you do countif and have two criteria "hit" or "miss".

[XOR LX]

Hi.

In general, yes, though it would help if you were a little more specific.

Regards

[Speshul]

The easy way would be to sum the countif's together

=SUM(Countif(A1:A10,"hit"),countif(a1:a10,"miss"))

[XOR LX]

The easy way would be to sum the countif's together

=SUM(Countif(A1:A10,"hit"),countif(a1:a10,"miss"))

That can also be abbreviated slightly to:

=SUM(COUNTIF(A1:A10,{"hit","miss"}))

Regards