I'd like to count all cells in a range where a given function evaluates to TRUE. The documentation for
COUNTIFS show text-matching and evaluation of
>, but nothing more sophisticated.
Here's an example with the function
ISDATE (could be any TRUE/FALSE function) as a sheet or as a table:
|1||7/28/2021||<- is a date|
|2||12/7/1941||<- is a date|
|3||=TODAY()||<- is a date|
|4||foobar||<- is not a date|
|5||<- is not a date|
|6||=COUNTIF(A1:A5, "=ISDATE()")||<- should evaluate to 3|
Is something like that possible?