Purpose of -- in SUMPRODUCT?

T

The Shaffer s

In several threads, I see the use of "--" before the arguments to SUMPRODUCT
function and was wondering what purpose a double-negative serves.

Ken shaffer
 
M

Myrna Larson

Where you see the --, it's in front of a formula that returns TRUE or FALSE.
SUMPRODUCT ignores TRUE/FALSE values. The -- converts the TRUE to 1 and FALSE
to 0.
 
Top