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

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

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

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

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

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