CountIf/SumIf criteria: easier way to represent blank cells and multiple match comparisons?
To the best of my knowledge, when using CountIf(s)/SumIf(s), the comparison criteria can be a cell reference or a string
There are other comparisons for which it is hard to create a working syntax; for example, wanting to count the number of cells that are blank
=Countif(A1:A100,"=") or =Countif(A1:A100,"=" & """") ...
or multiple different matches
This can instead be addressed using other formulas like Sumproduct, or an array formula, but I've always wondered why that second parameter doesn't allow a more sophisticated comparison, like
Really, allowing any other formula that can evaluate to true/false.
This would open up additional (easier) options to users who maybe don't know about, or don't feel confident in their use of array formulas