That's 2 minus signs (double unary operator.) They are used to coerce
logical true and false values to 1s and 0s. Let me see if I can find the
link to Bob's site which explains sumproduct very well:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

"ellebelle" wrote:

what does the symbol below mean in your formula above
--

i don't have it?

"1990" wrote:


Spot on, thanks.


--
1990
------------------------------------------------------------------------
1990's Profile: http://www.excelforum.com/member.php...o&userid=30100
View this thread: http://www.excelforum.com/showthread...hreadid=497851