Please enable JavaScript to view the comments powered by Disqus.


SUMPRODUCT(...(...MOD(...ROW(...INDIRECT(..."A"&B1&":A"&B2)),A3)=0)*1)

How to find exact multiples of 3 between 5 and 200.

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. 


Used Functions

Category: Math and trigonometry

Returns the sum of the products of corresponding array components

Syntax

SUMPRODUCT(array1, [array2], [array3], ...)

Category: 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])

Lets chat on this