SUMPRODUCT(...)

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().