Increasing function range by non-one increments.

**sulin360** · 06-28-2013, 07:53 AM

Hello, I'm new here and I know there are dozens of analogous threads around, but I still seem to struggle with this very basic concept. So, sorry in advance!

So, I'm implementing a COUNTIF function to count the number of occurrences of a single word every 200 rows starting from row number 2. This is the formula I use:

=COUNTIF(I2:I1201,"star.png")

Ideally, I want to be able to drag the function down to create a column of numbers that will give the results similar to typing

=COUNTIF(I2:I201,"star.png")
=COUNTIF(I202:I401,"star.png")
=COUNTIF(I402:I601,"star.png")
=COUNTIF(I602:I801,"star.png")
=COUNTIF(I802:I1001,"star.png")

and so on..

I believe there should be a very quick fix to this problem, but I can't seem to figure it out.

Thanks in advance!

**Ace_XL** · 06-28-2013, 08:03 AM

Start with

=COUNTIF(INDEX(I:I,200*(ROW(A1)-1)+2):INDEX(I:I,200*(ROW(A1)-1)+201),"star.png")

Copy down

**sulin360** · 06-28-2013, 08:17 AM

Thank you very much! The function you've provided works like a charm!

Can you please expand on what you have done, so me and other beginner users cab learn? Thanks!