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...
I fear that how I would approach such a problem is unlikely to be of value to many!
= LET(
wrapped, WRAPROWS(data, 4),
blockSum, BYROW(wrapped, LAMBDA(x, SUM(x))),
TOCOL(EXPAND(blockSum,,4,""))
)The formula uses the array shaping functions to block the data in 4 s across the sheet and then sums the rows to return block subtotals. To redistribute the values the subtotal list is padded with blanks before returning them to a column.
- 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.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);"")
