Using Google Docs/Drive Spreadsheets, you can write queries. However, if you have column letters in quotes, then they aren't updated as column order changes.
Is there a way to write these queries so they don't need to be updated every time a column is added or removed?
Is it possible to use named ranges in queries to solve this problem?
Here's an example: If you add a column after 'F', then column 'G' gets pushed to 'H' and the meaning of the formula changes.
=Query(B:J,"select avg(J) group by G")