SUMPRODUCT(...)
Count numbers between 74 and 174 that are divisible by 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
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().