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?
Google-sheets – How to do an aggregate function with multiple columns with a Google Sheets query
formulasgoogle sheetsgoogle-sheets-query
Related Solutions
Another way of doing it, is by using the AVERAGEIF formula.
Formula
=AVERAGEIF(A1:B1, ">0")
Screenshot
Related Topic
- Google Sheets Query – Query Function with Multiple Criteria
- Google-sheets – Google Sheets intersection query
- Google Sheets Query with Date and Time
- Google Sheets – Encode HTML Literals for Output Within Query Function
- Google Sheets – How to Select Multiple Columns Using =CHOOSE() Function
- Google Sheets – Using ARRAYFORMULA and QUERY for Multiple Columns
- Google Sheets – How to Query and Sort by Month
Best Answer
try like this:
to kill labels you can do:
to get average of two columns do: