Counting number of cells with a divisor of 6 in a row...

[450nick]

I'm trying to use a formula to count the number of cells with a divisor of 6 in but I'm having trouble.. I've tried =SUMPRODUCT(--(MOD(F11:J11,6))=0) but it doesn't seem to work - any ideas??

 

[dreid1011]

Perhaps this:

=SUMPRODUCT((MOD(F11:J11,6)=0)*1)

 

[450nick]

perfect, thank you!

 

[450nick]

It works fine, though some of the cells have "." in them (they need to unfortunately) - and if the range covers the cells with a "." in then it produces and error. Is there a way to count the cells where the mod formula doesn't produce an error?

 

[450nick]

Here's what I ended up with: (--SUMPRODUCT(IF(ISNUMBER(F4:O4),--(MOD(F4:O4,$D$32)=0*1),FALSE)) works good now!

 

[dreid1011]

Great! Glad you got it sorted after the fact.