COUNTIF Non Contiguous Cells Q
 

I want to create a formula that will Count the number of times cells
is a range are greater than 1.

Ordinarly I would use the formula =COUNTIF(F$10:F$168,"0"), however
my range is non-contiguous, it is however relative, in that the cells
I wish to Count are always 3 apart.

So if I was to avoid having to long type a formula with all the ranges
I want to count, how would I do it?

Thanks

COUNTIF Non Contiguous Cells Q
 

Hi

=SUMPRODUCT(--(MOD(ROW(A1:A15),3)=1),--(A1:A150))

Will count if row 1,4,7,10, 13 if 0

Hopes this helps.
....
Per

"Seanie" skrev i meddelelsen
...
I want to create a formula that will Count the number of times cells
is a range are greater than 1.

Ordinarly I would use the formula =COUNTIF(F$10:F$168,"0"), however
my range is non-contiguous, it is however relative, in that the cells
I wish to Count are always 3 apart.

So if I was to avoid having to long type a formula with all the ranges
I want to count, how would I do it?

Thanks

COUNTIF Non Contiguous Cells Q
 

Thanks Per

I didn't quite get the result I was looking for but I modified "=1" to
"1" and I did

Thanks

COUNTIF Non Contiguous Cells Q
 

You are welcome.

I am glad that you got the result you needed.

/Per

"Seanie" skrev i meddelelsen
...
Thanks Per

I didn't quite get the result I was looking for but I modified "=1" to
"1" and I did

Thanks