COUNTIF for multiples of 3
 

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.

COUNTIF for multiples of 3
 

=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)

"mwam423" wrote in message
...
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.

COUNTIF for multiples of 3
 

One way:

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


In article ,
mwam423 wrote:

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.

COUNTIF for multiples of 3
 

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!