I've got two columns of 10 numbers in Google Sheets. I'd like to average the numbers in both columns using a Google Sheets query. Something like this:
=query(A1:B11, "select avg(A&B)", 1) <- This does NOT work
What DOES work?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI've got two columns of 10 numbers in Google Sheets. I'd like to average the numbers in both columns using a Google Sheets query. Something like this:
=query(A1:B11, "select avg(A&B)", 1) <- This does NOT work
What DOES work?