View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
dpb dpb is offline
external usenet poster
 
Posts: 109
Default 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.

--