Forum Discussion
How to Add Multiple Data from Different Location with Intervals in Rows and Columns
I have 300 survey data from individual respondent, each data has a scale of 1 - 4 and have two to three subtopic every subject. How can I total or add every data based on their answer? Example: Res...
With SEQUENCE, if you prefer to use SUM and find dynamic arrays exciting.
=SUM(OFFSET(C2,SEQUENCE(MAX($A:$A),1,7,7),0))
Thanks for the help, I will try it too.