Forum Discussion
Formulas automatic every fifht row
I have a table, lets say I want to sumcell K18 and K19 in cell L19. There is over 600 rows and I want to copy this formula in every fifth row. How am I suppose to do this without manuell steps? I ha...
The MOD function is REST in Norwegian, and SUM is SUMMER.
HansVogelaar, than you very much.
I was aware of that (different function languages) but so opsessed about trying both in norwegian and english and did't see it was mixed up, so thank you so much. I am a totally novice in this.
I got i right now in the test table, but still struggeling with automatic copying to the 600 other rows.
The attachements "Formula_01" is showing that the formula is calculating the right answar.
The second picture "Formula_02" is showing one formula =HVIS(SUMMER(K16:K19)>M19;AVRUND(SUMMER(K16:K19)-M19;5)) that I want to copy exsactly the same (but every fifth row), but it does not function. I don't understand how to combine the two formulas to get it right.