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...
Hi,
(see the screenshot above)
In cell B4 apply below formula:
=TOCOL(EXPAND(TOCOL(BYROW(WRAPROWS(B4:B24, 5), SUM), 3),, 5, ""))
In cell C4 apply below formula:
=LET(wr, WRAPROWS(A4:A24, 5), TOCOL(EXPAND(TOCOL(BYROW(wr, MIN), 3),, 5, "")) & "-" & TOCOL(EXPAND(TOCOL(BYROW(wr, MAX), 3),, 5, "")))
Hope this helps.
Regards,
IlirU