Within the SUMPRODUCT formula given there are two implicit IF
structures that return TRUE or FALSE. The -- coerces these to 1 and 0.
Only if both structures return TRUE (1) will the result of multiplying
them equal 1 which will add 1 to the sum of the products.
For more detailed explanations do a Google search on Unary Minus.
Norman Harker MVP (Excel)