SUMPRODUCT(...)
How to find exact multiples of 3 between 5 and 200.
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 if a number is perfectly divisible by any other number for this case it is 3, by checking the remainder of the division. If the remainder is zero then it counts all such numbers to give the final answer.