Advancing row numbers in a Count formula by "x"

[Scadadude]

Hi I have a very long spreadsheet and every 24th row in a column L for example I am using a =COUNT(L28,P28,T28). The problem is I have 1440 rows that I am pulling data from and I only want the data from every 24th row. How can I make it where I can populate my 1440 rows automatically with the formula copying over and advancing the Rows by 24

=COUNT(L28,P28,T28)
=COUNT(L52,P52,T52)
=COUNT(L76,P76,T76)


Like the example above...I dont wanna have to manualy type this formula and change it 1440 times.

Thanks so much

Scadadude

 

[JTWood]

You need to copy the 23, empty cells above your formula - as well as the cell with your formula - when you do your copy and paste.

You should also be able to copy that cell specifically and paste it in the cell 24 rows down, but the method above is significantly faster.

 

[Scadadude]

Lemme explain a little better....I have 1440 cells each with a Count Formula in it. I need the formula to advance the row numbers in them by 24.

 

[shift-del]

Hi

Try this in row 1 and copy down.

=IF(MOD(ROWS(U$1:U1),24)=4,COUNT(L1,P1,T1),"")