Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT
Hi,
I saw this formula: =SUMPRODUCT(--(A2:A65536<""),--(B2:B65536="")) And I have no idea what "--" means, I tried searching the manual and the internet but found nothing. ArthurN |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT
Have a look at the following link...
http://www.mcgimpsey.com/excel/formulae/doubleneg.html Cheers! In article , ArthurN wrote: Hi, I saw this formula: =SUMPRODUCT(--(A2:A65536<""),--(B2:B65536="")) And I have no idea what "--" means, I tried searching the manual and the internet but found nothing. ArthurN |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT
To put it simply, Sumproduct() is a function which ignores alphabetic cells, the operator -- ( called Unary Minus ) transforms alpahabetic cells into numbers : 0 and 1, thus allowing combination with all other numeric cells ... Hope this clarifies Carim -- Carim ------------------------------------------------------------------------ Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259 View this thread: http://www.excelforum.com/showthread...hreadid=531246 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT
Carim Wrote: To put it simply, Sumproduct() is a function which ignores alphabetic cells, the operator -- ( called Unary Minus ) transforms alpahabetic cells into numbers : 0 and 1, thus allowing combination with all other numeric cells ... Hope this clarifies Carim I had never encountered this problem before. I discovered Sumproduct he http://www.excel-vba.com/e-formula-sumproduct.htm He uses an asterisk in place of the comma, like this: =SUMPRODUCT((A1:B10=C1)*(B1:B10)). This works just fine. I understand the use of the double negative above, but I don't see why using the asterisk would alleviate that problem. Can someone explain what's going on there? -- Teodomiro ------------------------------------------------------------------------ Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140 View this thread: http://www.excelforum.com/showthread...hreadid=531246 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT
Here's a more extensive explanation by Bob Philips:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Teodomiro" wrote in message ... Carim Wrote: To put it simply, Sumproduct() is a function which ignores alphabetic cells, the operator -- ( called Unary Minus ) transforms alpahabetic cells into numbers : 0 and 1, thus allowing combination with all other numeric cells ... Hope this clarifies Carim I had never encountered this problem before. I discovered Sumproduct he http://www.excel-vba.com/e-formula-sumproduct.htm He uses an asterisk in place of the comma, like this: =SUMPRODUCT((A1:B10=C1)*(B1:B10)). This works just fine. I understand the use of the double negative above, but I don't see why using the asterisk would alleviate that problem. Can someone explain what's going on there? -- Teodomiro ------------------------------------------------------------------------ Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140 View this thread: http://www.excelforum.com/showthread...hreadid=531246 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
=SUMPRODUCT
Ragdyer Wrote: Here's a more extensive explanation by Bob Philips: http://www.xldynamic.com/source/xld.SUMPRODUCT.html Perfect. Thank you! -- Teodomiro ------------------------------------------------------------------------ Teodomiro's Profile: http://www.excelforum.com/member.php...o&userid=33140 View this thread: http://www.excelforum.com/showthread...hreadid=531246 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=SUMPRODUCT formula is counting the blank cells as well as zero's | Excel Worksheet Functions | |||
=SUMPRODUCT not working | Excel Worksheet Functions | |||
=SUMPRODUCT | Excel Worksheet Functions | |||
=SUMPRODUCT formula help | Excel Worksheet Functions | |||
=SUMPRODUCT and =IF | Excel Worksheet Functions |