"Joel" wrote in message
...


Sumproduct doesn't know how to multiply {true * 1}. the -- changes this to
{1 * 1}

=SUMPRODUCT(({TRUE,TRUE})*({1,1}))

=2