SUMPRODUCT(...)
Find numbers between 100 and 200 that are exactly divisible by 2, 3 and 5.
Used Functions
Category: Math and trigonometry
Returns the sum of the products of corresponding array components
Syntax
SUMPRODUCT(array1, [array2], [array3], ...)
Practice SUMPRODUCT Formula at Sheetzoom
SUMPRODUCT formula at Microsoft helpCategory: Math and trigonometry
Returns the remainder from division
Syntax
MOD(number, divisor)
Category: Lookup and reference
Returns the row number of a reference
Syntax
ROW([reference])
Category: Lookup and reference
Returns a reference indicated by a text value
Syntax
INDIRECT(ref_text, [a1])
0
The formula used MOD to find if the division has remainder of zero, that is only condition for being perfectly divisble. If the condition is meet, the number is multiplied with 1 and then summed up with SUMPRODUCT to give the final count.