Category: Math and trigonometry
Returns the sum of the products of corresponding array components
SUMPRODUCT(array1, [array2], [array3], ...)
Category: Math and trigonometry
Returns the remainder from division
MOD(number, divisor)
Category: Lookup and reference
Returns the row number of a reference
ROW([reference])
Category: Lookup and reference
Returns a reference indicated by a text value
INDIRECT(ref_text, [a1])
0
This formula checks for the remainder of the numbers by using MS Excel formula MOD(), if the returned value is zero then the number is perfectly divisible, otherwise not. In case it is perfectly divisible, we count 1 and that is added by SUMPRODUCT().