If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
SUMPRODUCT arguments
You are getting -2 because you are using three minus signs for each
argument. You need only two. The third one is changing your answer to negative. Regards, Fred. "Chris T-M" wrote in message ... 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. |
#3
|
|||
|
|||
SUMPRODUCT arguments
See this:
http://xldynamic.com/source/xld.SUMPRODUCT.html -- Biff Microsoft Excel MVP "Chris T-M" wrote in message ... 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. |
#4
|
|||
|
|||
SUMPRODUCT arguments
"Fred Smith" wrote in message ... You are getting -2 because you are using three minus signs for each argument. You need only two. The third one is changing your answer to negative. ....and because there are an odd number of conditional tests, if there were an even number, it would have worked, as would one, 5 or any other odd number of dashes (not that I think it should ever be any other number than 2) |
Thread Tools | |
Display Modes | |
|
|