using functions in COUNTIF criteria
Do you know of any documentation of Excel regarding specifying complex criteria for COUNTIF - e.g. conditions using functions, referring to neighbor cells, etc.
E.g. something like (this one doesn't work)
=COUNTIF(A1:A1000; "OR(ISTEXT(A1); ISNUMBER(B1)")
Solution 1:
Complex criteria are not available for COUNTIF(S), just the basic comparisons (=,<>,<,>,<=,>=). To do more complex comparisons, you can use SUMPRODUCT and --
For example, to count where there is text in A, and a corresponding number in B, you could use:
=SUMPRODUCT(--(ISTEXT(A1:A1000)),--(ISNUMBER(B1:B1000)))