Counting Rows - Fill ???

[klafert]

I would like a formula tha will count columns. I was using the fill down in
series, its been a while, but I though I could tell it to start at 1 end at
27 and start over at 1 and goto 27 until all the lines that contains data or
in a range are counted.

When I use the fill down I put the stop value at 27 and in the 1st column I
have a 1 and that works. But I have to Manually do this ever 27 columns. I
thougth I could use trend or???

 

[Biff]

Try this:

=MOD(ROWS($1:1),27)+(MOD(ROWS($1:1),27)=0)*27

Copy down as needed.

Biff