Forum Discussion
Jump over a row when dragging down a formula
Hi, I am trying to put in a formula in excel. The problem is that every 7th row I have a row that I don't want to compute but instead jump to the next row but I still want to have the result ben...
You could simply drag down the formula, and clear the 'unwanted' cells by ctrl-clicking these and press 'delete' once selected. A sum of the range of cells still computes, even if the range contains blank cells.
Is that what you mean?
Regards,
Could be
=IF(MOD(ROW()-1,7), <formula to compute>, <blank or another formula>)