Google Sheets QUERY – SUM, AVERAGE, COUNT, GROUP BY Aggregate Functions Tutorial – Part 5

Video is ready, Click Here to View ×


Video tutorial series about QUERY function in Google Sheets.

In this tutorial we’ll cover how to use QUERY function in Google Sheets to get aggregate data using SUM, AVG, COUNT functions and Group By Statement.

Google Sheets

Website:

sql tutorials

11 Comments on “Google Sheets QUERY – SUM, AVERAGE, COUNT, GROUP BY Aggregate Functions Tutorial – Part 5”

  1. It will be great to have a video on format with the query function (like how to query results and format as currency, etc). If you agree, up vote this comment if you agree so the author notices it.

  2. thanks. it was a nice video. I am curious about "group by" . does it only work in english? actually I have dealt with some data with korean letters. but it didn't work at all. I am sure that there is no error in syntax. I did same things what you explained.

  3. Thank you! Your video saved me! I missed that "D" in 5:55 after "group by" in my work and everything goes wrong. Thanks a lot!
    p.s. I wrote ="select C, D, count (E), group by C" and it returns "#VALUE!", annoyed me for a while..

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.