Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct | Excel Worksheet Functions | |||
sumproduct causing memory errors? | 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 |