COUNTIF for multiples of 3

[mwam423]

i'm assuming COUNTIF is function i need to use, however, if there is better
way i'm all ears. have row of values and would like to be able to count
number of values which are a multiple of three, i.e. if i have row of numbers
from 1 to 9, formula would return 3; numbers 1 to 10, returns 3, numbers 1 to
11, 3; numbers 1 to 12, returns a 4. the number of values will vary and not
be contiguous but will/can be in ascending order.

 

[Bob Phillips]

=SUMPRODUCT(--(A1:A100<>""),--(MOD(A1:A100,3)=0))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(rng<>""),--(MOD(rng,3)=0))

 

[mwam423]

hi bob, and JE, appreciate the quick response, that's exactly what i need!
bob, figured out that conditional format question from last week, i just
needed to get my reading comprehension to middle school level =D thanks for
all your help!