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...
This formula is in cell C2 and filled down:
=IF(MOD(A2,5)=0,SUM(OFFSET(B2,0,0,5)),"")This formula is in cell D2 and filled down:
=IF(MOD(A2,5)=0,A2&"-"&A2+4,"")Does this return the intended output?