Count cell range that doesn't contain specific strings or is empty

[Pr0]

Hi.
I have this:

=COUNTIF(A1:A5, {"<>String1","<>String2"})

How do I add "empty"? (cell range that doesn't contain "String1", "String2" or is empty)

PR

[JLGWhiz]

Use CountIfs function. It allows two ranges and two criteria.

[Pr0]

=COUNTIFS(A1:A5, "<>String1", A1:A5, "<>String2", A1:A5, "<>")
This works, thank you.

Is it possible to do it as an array, though?
COUNTIFS(A1:A5, {"<>String1", "<>String2", "<>"}) —> doesn't work

PR

[sandy666]

maybe:
=SUMPRODUCT((A1:A9<>"string1")*(A1:A9<>"string2")*(A1:A9<>""))

edit:
Oops, I maded sum instead of count

[bebo021999]

=COUNTIFS(A1:A5, "<>String1", A1:A5, "<>String2", A1:A5, "<>")
This works, thank you.

Is it possible to do it as an array, though?
COUNTIFS(A1:A5, {"<>String1", "<>String2", "<>"}) —> doesn't work

PR

COUNTIF(A1:A5,"<>"&"") works separately, but not in array format like this: COUNTIF(A1:A5,{...,...,"<>"&something})

[Pr0]

Hmm, I'm not sure I understood that. Where do "String1" and "String2" go?

PR