Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I have used the sumproduct function a lot and thinks it is very good. My
problem is that I do not know the functions of different characters that can be used in the sumproduct function Ie. what is the "--" in front of a sumproduct function : "Sumproduct(--(xx and when to use "*" and "+" and ",". Does anyone have any "guide" to sumproduct that can explain theese things and probably other things? -- Peter B Norway |
#2
![]() |
|||
|
|||
![]()
For an explanation of the double unary usage, see:
http://www.mcgimpsey.com/excel/formulae/doubleneg.html and http://tinyurl.com/5fvwo To learn about SUMPRODUCT, see: http://www.xldynamic.com/source/xld.SUMPRODUCT.html HTH Jason Atlanta, GA -----Original Message----- I have used the sumproduct function a lot and thinks it is very good. My problem is that I do not know the functions of different characters that can be used in the sumproduct function Ie. what is the "--" in front of a sumproduct function : "Sumproduct(--(xx and when to use "*" and "+" and ",". Does anyone have any "guide" to sumproduct that can explain theese things and probably other things? -- Peter B Norway . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sumproduct causing memory errors? | Excel Worksheet Functions | |||
Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
Sumproduct function not working | Excel Worksheet Functions | |||
adding two sumproduct formulas together | Excel Worksheet Functions |