sumproduct question
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 |
sumproduct question
The double unary minus converts a Boolean TRUE or FALSE to a number 1 or 0.
-- David Biddulph "Harvey" wrote in message ... 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 |
sumproduct question
See this:
http://xldynamic.com/source/xld.SUMPRODUCT.html -- Biff Microsoft Excel MVP "Harvey" wrote in message ... 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 |
All times are GMT +1. The time now is 10:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com