SUMPRODUCT(...)
How to find numbers perfectly divisible by 14 between 20 and 1056.
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 uses the fact that for a perfectly divisible number, the numerator must be zero.