sumproduct Meaning "(--"

[further]

I have found a sumproduct formula and need to understand what it is doing?

sumproduct (--($v9:$v90=A28),$AA9:$AA90,AG9:AG90)

I understand a normal sumproduct but what is the "(--" doing?

 

[lrobbo314]

Maybe someone can give a more detailed answer, but I believe that it changes the values in the array from True/False statements to 1's and 0's so that the formula can calculate the total.

 

[Jonmo1]

Welcome to the board..

It's creating an array of 1's and 0's
Based on the results of the expression.
(V9:V90=A28) <- this is an expression that returns either True or False
One true/false result for each cell in the range.
The -- coerces True to 1, False to 0

 

[BilboB]

I have found a sumproduct formula and need to understand what it is doing?

sumproduct (--($v9:$v90=A28),$AA9:$AA90,AG9:AG90)

I understand a normal sumproduct but what is the "(--" doing?

It is essentially the same as saying SumProductIf which doesn't exist, so SumProduct If the statement is true.

e.g.

=((SUMPRODUCT(--(A16:A25="Y"),B16:B25,C16:C25))

In this example if the values in column A contain a "Y", then SumProduct their respective rows in columns B and C, otherwise don't sum them.

Really useful formula!