Double unary operator

Dear Community, Good morning.

I am seeking clarification over something which I have read this morning.

Is --( a replacement for * when formatting a sumproduct calculation?

ie, is:

=sumproduct((array1=condition1)*(array2=condition2)*(array3))

the same as

=sumproduct(--(array1=condition1),--(array2=condition2),(array3))

Thanks v much

Yes - though the outer parentheses re: array 3 are not required in either example.

Both approaches have their advantages over the other... for ex:

Double unary is regarded as being slightly quicker
(though if you're worried about efficiency then you shouldn't be using SUMPRODUCT)

Double unary also allows for non-numerics in array3 (the * does not given explicit coercion)

Multiplication allows for arrays with differing dimensions (double unary does not)

Double Unary is open to error with direct volatile precedents in XL2007 depending on updates installed on client

Thanks Gents for the clarification.

The link you posted Bob was the one which I was reading, but by the time I got to the format section my brain was fried.

Have a good day.