Forum Discussion
tanyaandrews91
Jun 12, 2020Copper Contributor
Add multiple columns of data (like a spreadsheet with grades) that are not adjacent
Sorry for this very elementary question - how do I add multiple columns of data (like a spreadsheet with grades) that are not adjacent?
1 Reply
Sort By
- mathetesSilver Contributor
If the grades are in columns A, C, and E
you could start in row 2, column F with this formula
=A2+C2+E2
and then copy and paste that same formula down to all the rows where you need it
If you need further help, feel free to post a copy (devoid of any real names or identifiable data) of your spreadsheet and someone here can help ...