Hi JoAnn
Further to Cimjets answer.
The -- is called a Double Unary and the simple way to see Cimjets answer is
to take them out of the formula and see the result in the formula bar.
It will refer to True or false rather than a mathematical result

Regards
Michael M

"JoAnn" wrote:

Great! Thanks.
--
JoAnn


"Cimjet" wrote:

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