It's impossible to say without knowing what you want this formula to do


(--(ProblemClosedDate=$B21)--(ActionClosedDate=$C21)


is the same as


((ProblemClosedDate=$B21)+(ActionClosedDate=$C21 )

so if the first range returns 3 TRUE and the second 2 TRUE it will
total up to 5 so it is similar to an OR function not an AND meaning that
if

ProblemClosedDate=$B21 returns FALSE for one particular row/column
and ActionClosedDate returns TRUE for the same particular row/column

it will still count as 1 while


(--(ProblemClosedDate=$B21),--(ActionClosedDate=$C21)


will return zero for the same, to get 1 for the latter both criteria need to
be TRUE so it would need 2,


SUMPRODUCT(--(ProblemClosedDate=$B21)OR(ActionClosedDate=$C21 )AND(ProblemClosedDate<"")AND(ProblemOpenDate<$F2 1)AND(LOB=$E21)AND(DueDateVersion$D21))


meaning that if the first 2 criteria are TRUE they will count as 2 as long
as the other criteria are TRUE, if one is TRUE and the other is FALSE they
will count as 1, if you would use the comma between the first 2 both would
need to be TRUE to count as 1



--


Regards,


Peo Sjoblom



"Paul Dennis" wrote in message
...
As an example I have
=SUMPRODUCT(--(ProblemClosedDate=$B21)--(ActionClosedDate=$C21),--(ProblemClosedDate<""),--(ProblemOpenDate<$F20),--(LOB=$E21),--(DueDateVersion$D21))
and it returns 21. I have checked my numbers and the result matches what I
want. If I however add a comma after the first criteria then it returns 0
which is incorrect.

My initial though was the , changed the criteria from an additional filter
to an and i.e. both the criteria had to match.

"Peo Sjoblom" wrote:

If you use the unary minuses you would always need a comma as a delimiter
so
your second example is wrong. You can also use

sumproduct((.....)*(....))

http://www.mcgimpsey.com/excel/formulae/doubleneg.html


--


Regards,


Peo Sjoblom


"Paul Dennis" wrote in message
...
Hi,

I know what -- does however I have seen it a couple of ways, syntax
sumproduct(--(criteria),--(criteria)) and also
sumproduct(--(criteria)--(criteria))

what is the difference in using the , or not?

thx