sumproduct question

[Harvey]

In the following formula what does the -- mean?
=sumproduct(--(a2:a10=d2),--(b2:b10>=e2))

the spreadsheet is:

a b c d e
1 Item Qty
2 pen 5 pen 10
3 pencil 9
4 binder 9
5 pen 6
6 pen 15
7 binder 12
8 pencil 10
9 binder 6
10 pen 11

Harvey Mandel

 

[David Biddulph]

The double unary minus converts a Boolean TRUE or FALSE to a number 1 or 0.

 

[T. Valko]

See this:

http://xldynamic.com/source/xld.SUMPRODUCT.html