Get Every Other 2 Row

[bines53]

Hello everyone !

This function =SUM(--(MMULT(--(A1:F11=3),{1;1;1;1;1;1})>0))
Gives a result, there are a number of lines in the 3, at least once.

I want a similar function, check, every second row, in range.
The desired outcome is 4.

Thank you!

 

[John Jairo V]

Hi @bines53.

Try this formula:
=SUM(--(MMULT((A1:F12=3)*ISEVEN(ROW(A1:F12)),{1;1;1;1;1;1})>0))

Blessings!

 

[bines53]

Hi John,

Excellent !

How to do it when,every Third row ?

Thank you!

 

[Somendra Misra]

Hi David,

Modifying @John Jairo V formula can you try this one:

=SUM(MMULT((A1:F12=3)*(MOD(ROW(A1:F12),3)=0),{1;1;1;1;1;1}))

Regards,

 

[bines53]

Hi Somendra,

Excellent !

Thank you!