Sum product formula with conditions
On 7/20/2019 7:47 AM, dpb wrote:
....
If the use of a double negation is such a highly recommended
functionality, it's interesting it never is mentioned as being needed or
the manner in which one should cast the logical to numeric in the
documentation for SUMIF() and friends where it seemingly is most prevalent.
Of course, the underlying problem is that the Excel parse engine doesn't
have sufficient intelligence in it to evaluate enclosing () so that one
is forced to write the explicit cast operation in one form or the other.
A "real" programming language doesn't need either...
--
|