Sum product formula with conditions
On 7/18/2019 10:53 AM, GS wrote:
*using double negative in Excel formula
"This method is mostly used in SUMPRODUCT formulas to convert the
conditional arrays that evaluates to TRUE/FALSE into 1/0."
Yes, that's exactly what N() is for...instead of the double-negative. I
had forgotten the function name is just N instead of NUM, my bad on that
part.
--
|