Hi all,
I found a wonderful answer from Aladin Akyrek on this thread which solved my problem. However I do not understand it works, and as the thread was 4 years ago I open this new thread to post my question:
How does SUMPRODUCT work in the following formula
( it applies to COUNTIF too — SUMPRODUCT(COUNTIF(range_to_check_in_data, range_data)) )
knowing the prototype of this function:
In our case, we have only one argument, so what kind of magic is happening here?
I found a wonderful answer from Aladin Akyrek on this thread which solved my problem. However I do not understand it works, and as the thread was 4 years ago I open this new thread to post my question:
How does SUMPRODUCT work in the following formula
Code:
SUMPRODUCT(SUMIF(range_to_check_in_data, range_data, range_to_sum))
( it applies to COUNTIF too — SUMPRODUCT(COUNTIF(range_to_check_in_data, range_data)) )
knowing the prototype of this function:
and that it multiplies all the components of the arrays and then return the sum of these products.Syntax
SUMPRODUCT(array1,array2,array3, ...)
Array1, array2, array3, ... are 2 to 255 arrays whose components you want to multiply and then add.
In our case, we have only one argument, so what kind of magic is happening here?