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...
I've done lots of rating excel sheets in the past and the was I do it is much simpler that the setup you designed but it it more precise to do calculation. Hopefully, this revised worksheet would work for you so it will be more easier to load data since each column represents one respondent. I filled in the calculations for the first few cells in the Tally sheet and I'm pretty sure you could fill in the rest with the same formula pattern and just different rows.
- Thanks a lot, I'll surely try this one too.
