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...
Hi, thank you very much.
I could not find any way to get this working. I got a message about "LET", it said
'The first name must be a valid name'.
I tried to translate the functions to norwegian, but with no help.
Thanks anayway. I have to few skills about functions.
I could not find any way to get this working. I got a message about "LET", it said
'The first name must be a valid name'.
I tried to translate the functions to norwegian, but with no help.
Thanks anayway. I have to few skills about functions.
Attached file repeats PeterBartholomew1 formula
Try to open it in your environment to check if formula works.
- SergeiBaklan
if the array function is not needed, then a mod loop with bottomright doubleclick to expand
=IF(MOD(ROW()-2;4)=1;SUM(C3:C6);"")
