Forum Discussion
How to sum chain values from N-number cells?
Hello, I have data of people by age, but 100 different values on a line chart would look... bad. Hence the need to group ages in sets of 5 or 10 on a separe line in chain, but what is the functio...
how about this:
=MMULT(WRAPROWS(B2:B101,5),{1;1;1;1;1})and for the group names you can use:
=BYROW(CHOOSECOLS(EXPAND(WRAPROWS(A2#,5),,6,"-"),1,6,5),CONCAT)or maybe more simply
=SEQUENCE(20,,0,5)&"-"&SEQUENCE(20,,4,5)