ExcelBanter - sumproduct

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sumproduct (https://www.excelbanter.com/excel-discussion-misc-queries/25028-sumproduct.html)

snax500

sumproduct

I was having trouble with a SumIf function to a linked file. I searched
the newsgroups and found an alternative using Sumproduct. In this
formula:

SUMPRODUCT(--($B$8:$B$800=1),'C:\MyDocs\[2005exp.xls]Sheet1'!$C$8:$C$800

what does the SUMPRODUCT(--( do? Why the double dashes?

Thanks

Bob Phillips

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

"snax500" wrote in message
ups.com...
I was having trouble with a SumIf function to a linked file. I searched
the newsgroups and found an alternative using Sumproduct. In this
formula:

SUMPRODUCT(--($B$8:$B$800=1),'C:\MyDocs\[2005exp.xls]Sheet1'!$C$8:$C$800

what does the SUMPRODUCT(--( do? Why the double dashes?

Thanks

All times are GMT +1. The time now is 05:09 PM.