sumproduct question

H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top