Click on the reference cell you want to always use in the formula and then press the F4 key. In the Columns to repeat at left box enter the reference of the columns that contain the row labels. Click the Range button and select the cell range A2A7.
And in cell A4 enter formula IF A331A31.
Depending on how you built the spreadsheet this could be as easy as just copying the formulas down or across and changing the inputs. For other reference cells please repeat the above step. IF MOD ROW -1425SUM OFFSET AO2 ROW -42442404241 It will perform the calculation only in every 425th row starting in row 426. Apply formula to an entire column or row without dragging by Kutools for Excel.