Need to count up every n cells

I am looking to create a function that will count up every nth cell horizontally for a lookup table I have but my brain just isn't clicking on how to do it.

ie:

1

0

0

2

0

0

3

0

0

4

I have been searching on this and am wondering if MOD or OFFSET or Countif based on position of first cell would work? I am at a loss, any clues to point me in the right direction would be amazing.

Originally Posted by Sambo kid

exactly what are you looking to count? In other words, simply those cells that don't have a 0 in them you could simply use a countif like =COUNTIF(A3:J3,">"&0)
But I suspect there is more to your request.

You suspected correct, I was worried I didn't explain it well. What I really want to do is enter a 2 into a cell and have a function count up consecutively every 2 cells. So it would generate 1,0,2,0,3,0,4 or if I put a three in it it would generate 1,0,0,2,0,0,3,0,0,4 across cells horizontally. Does that make sense?

Originally Posted by Sambo kid

so you are looking for a formula to populate a row of cells depending on the particular value in another cell, not count every Nth cell as the title suggests right?

Yeah, that is a better way to explain it. That is why I put count UP in the title, because I want it to count up by 1 in every nth cell. Essentially a formula to recreate what I had in the inserted table.

Im getting closer, I can feel it. =IF(MOD(ROW(),$C$1),"N","Y")

That gives me a Y every nth (in this case, ive populated C1 with a 3) so if I copy this formula down on A1 to A50, I get below:

N

N

Y

N

N

Y

N

N

Y

Now how would I replace those Y's with cells that count up by one each time the if statement is FALSE?

OK, I really went on a journey there. It turns out that after 2 days of bashing my head against a wall has unstuck some part of me that could figure this out. In case anyone cares, =IF(MOD(COLUMN(),$A$4),0,(COLUMN())/$A$4) works where starting at A1, if I copy this formula to the right 50 cells and reference A4 which has a number in it (my nth), it will count up each nth by 1. So it would look like this: 0,0,1,0,0,2,0,0,3,0,0,4,0,0,5 etc...