Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT arguments
Working with SUMPRODUCT for the first time. Can someone explain the use of
the dashes following the command? I've seen from none to (I think) 4... I started with: SUMPRODUCT(--(range=x),--(range=y)) I am currently trying to use 3 arguments, but the answer I expected was +#, but I am getting a -#. SUMPRODUCT(---([RANGE S]="REPORT"),---([RANGE 1 DUE]=[FIRST OF THE MONTH],---([RANGE 1 DUE]<=[END OF THE MONTH])) The actual answer is 2, but I get -2. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Too few arguments | Excel Worksheet Functions | |||
IF-more than 7 arguments | Excel Discussion (Misc queries) | |||
And, if, arguments.... | Excel Worksheet Functions | |||
sumproduct to count two arguments | Excel Worksheet Functions | |||
Can sumproduct do two {x,y,z} arguments? | Excel Worksheet Functions |