Can someone explain me this formula

[smalik]

=SUMPRODUCT(--(A1=sheet!$B$2:$B$5697),--(sheet!$E$2:$E$5697))

Can someone explain to me the significance of -- in the above formula. I remember seeing the -- used in other formulae as well but never understood.

Thanks.

 

[VoG]

The -- is used to coerce arrays of False/True values into the numbers 0/1 that sumproduct can work with.

 

[smalik]

The -- is used to coerce arrays of False/True values into the numbers 0/1 that sumproduct can work with.

Thanks. This is helpful but can you give me an example. I am trying to learn this so that I can use it if and when there is a need. Thanks in advance for your help and time.

 

[VoG]

Here's an example with explanation http://www.mrexcel.com/forum/showthread.php?t=70547

 

[smalik]

Great! thanks. I 've got some reading to do.