Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Hi, can anyone inform me the reason for using the "--" in formulas
(especially the sumproduct function) Someone referred me to this link but I cannot decipher HOW the formula works. http://www.nwexcelsolutions.com/adva...ction_page.htm (Question 1) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
hi the double unary "--" which converts text value into numeric is mostly used for ignoring errors..!! -via135 WBTKbeezy Wrote: Hi, can anyone inform me the reason for using the "--" in formulas (especially the sumproduct function) Someone referred me to this link but I cannot decipher HOW the formula works. http://www.nwexcelsolutions.com/adva...ction_page.htm (Question 1) Thanks -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=549118 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
to sum text
regards "WBTKbeezy" escreveu: Hi, can anyone inform me the reason for using the "--" in formulas (especially the sumproduct function) Someone referred me to this link but I cannot decipher HOW the formula works. http://www.nwexcelsolutions.com/adva...ction_page.htm (Question 1) Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "WBTKbeezy" wrote in message ... Hi, can anyone inform me the reason for using the "--" in formulas (especially the sumproduct function) Someone referred me to this link but I cannot decipher HOW the formula works. http://www.nwexcelsolutions.com/adva...ction_page.htm (Question 1) Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
Not really mate, it is used to coerce True/False arrays into 1/'0 arrays
which can then be summed. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "via135" wrote in message ... hi the double unary "--" which converts text value into numeric is mostly used for ignoring errors..!! -via135 WBTKbeezy Wrote: Hi, can anyone inform me the reason for using the "--" in formulas (especially the sumproduct function) Someone referred me to this link but I cannot decipher HOW the formula works. http://www.nwexcelsolutions.com/adva...ction_page.htm (Question 1) Thanks -- via135 ------------------------------------------------------------------------ via135's Profile: http://www.excelforum.com/member.php...o&userid=26725 View this thread: http://www.excelforum.com/showthread...hreadid=549118 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct
No, it is used to coerce True/False arrays to 1/0 arrays. SP is generally
used to test multiple conditions, and these tests return an array of TRUE or FALSE. This is of no use to get a count, so that needs to be changed to arrays of 1 and 0, which is what the double unary does. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Marcelo" wrote in message ... to sum text regards "WBTKbeezy" escreveu: Hi, can anyone inform me the reason for using the "--" in formulas (especially the sumproduct function) Someone referred me to this link but I cannot decipher HOW the formula works. http://www.nwexcelsolutions.com/adva...ction_page.htm (Question 1) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
Sumproduct | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |