Paul -

Insert a new column or use an empty column and enter this formula

=mod(row(),6)=0
or, if you have a header row make it
=mod(row()-1,6)=0
This will return TRUE for every 6th row, FALSE otherwise
Filter on the TRUE values
Enter your formula(s) in the first filtered row
Copy the formulas
Select the entire range
Press the F5 key, click on Special, and select Visible Cells Only
Paste
Undo your filter



"Paul" wrote:

My worksheet has blocks of 6 rows for each item I'm reporting on. I want to
apply a formula to the last row in each section, using data from the previous
column and the other cells in the same column, i.e

b6 = sum(a6-b1-b2-b3-b4+b5)
c6 = sum(b6-c1-c2-c3-c4+c5) etc.

I think I can get to each 6th row, by

if(mod(row(a1:a240) - 1),6) = 0, but not sure how to apply the formula

Thanks for any suggestions