Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT use of --() syntax
I was wondering if someone could explain to me how the --() syntax works.
Also the use of SUMPRODUCT((condition1)*(condition2)). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT use of --() syntax
Stephen,
The use of Sumproduct and the double unary are explained here http://www.xldynamic.com/source/xld.SUMPRODUCT.html Mike "Stephen Lloyd" wrote: I was wondering if someone could explain to me how the --() syntax works. Also the use of SUMPRODUCT((condition1)*(condition2)). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT use of --() syntax
Thanks Mike, that was a great explanation.
"Mike H" wrote: Stephen, The use of Sumproduct and the double unary are explained here http://www.xldynamic.com/source/xld.SUMPRODUCT.html Mike "Stephen Lloyd" wrote: I was wondering if someone could explain to me how the --() syntax works. Also the use of SUMPRODUCT((condition1)*(condition2)). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct syntax when using AND, OR | Excel Worksheet Functions | |||
IRR Syntax | Excel Worksheet Functions | |||
SQL syntax | Excel Worksheet Functions | |||
Sumproduct syntax - more complex | Excel Discussion (Misc queries) | |||
VBA syntax | Excel Discussion (Misc queries) |