Hi JoAnn

The -- stuff changes trues and falses
to 1's and 0's. Logic expression to numeric expression.
Regards
Cimjet

"JoAnn" wrote in message
...
I sometimes see formulas with -- before a set of parenthesis (sample
formula
below), can anyone tell me what the purpose of it is? I can't seem to
find
it documented anywhere.

For example:
=SUMPRODUCT(--(MONTH(b7:b400)=MONTH(D417)), --(YEAR(b7:b400)=YEAR(D417))

Thanks
--
JoAnn