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...
Hi 🙂 Thanks for the quick reply, maybe I can't explain properly what I want to happen, if you have time please check the attached file so you can have more idea on what I'm trying to do. Thanks 🙂
Let me suggest a different approach altogether. This involves a change in the way you record the responses, as illustrated on the attached. And then let Excel's Pivot Table capability do the tallying for you.
Please note: I did not try to replicate your responses, just randomly entered responses on the 1-4 scale into this different way of recording. That is to say, I am just illustrating the process.
You can test if by changing the results for the first three respondents to be the same as yours. Just know that it will work with your data and you won't need to write any formulas at all. Just make use of the Pivot Table.
- Thank you very much, I will consider this one too.