NorthStar Analytics
Pricing

HiDocs High-Quality Ghost Documentation Theme

How to Use AVERAGE Function in Google Sheets?

How to Use AVERAGE Function in Google Sheets?

One of the functions that we use frequently in daily life is averaging. Especially if we are dealing with sales data, it has many uses such as average daily sales, average discount applied. While working with Google Spreadsheets, we can write the function manually as well as access it with the toolbar or the menu. Let's examine it in order.

How to use the average formula by writing it manually?

We will take the daily average of sales in our sales table. For this:

  1. Come to the cell where you want to print the result
  2. =AVERAGE (cell range)

=AVERAGE(B2:B10) for the first column was used. When you select the cell range, the function auto-fills. I can apply the function for each column individually. But instead, if we move the first calculated field to the right, the formula will average out the other columns.

If we double-click on the calculation field at the end of the second column, we can see the automatic calculation made by the table.

If we examine the function, it got the cell range right. Likewise, if we drag the small square on the lower right corner of the cell to the right, it will do the calculation within the other columns.

How to average using formula icon in toolbar?

In the example above, we manually typed the function and selected the cell range. If we want to use the toolbar:

  1. Select the cell range you want to average
  2. Go to toolbar -> Click formula icon
  3. Average

When we click Average, the result will be written at the bottom of the column (here is the green part). If we want it to be applied in other columns, it will be enough to drag the cell where the result is written in the direction we want.

To apply this function, we selected a range of cells and clicked on the function. Don't think that if we want to get it for the columns in the whole table, we have to select the whole table. If you do, it will calculate the average of the whole table and write it in one cell. The way to average for individual columns is to get a column first, then drag.

I dragged it for the whole column and they all averaged. For the column with text, it gave an error. The media function only works on columns containing numeric values.

How to use the average function with the menu?

In addition to the toolbar and handwriting, we can also access the functions using the menu.

  1. Select the cell range you want to average
  2. Menu-> Insert-> Function->Average
Make your business data transparent!
  • Subscribe to a package

    Subscribe and explore the limits of your business with data or thinking to expand your agency value proposition with Google Data Studio dashboards?

  • Request unlimited dashboards

    You can request as many dashbaords you might have and as many revisions as you might need. We create a queue of your tasks, the first tasks that come in are the tasks that we’ll deliver first.

  • Your Data Studio Department

    Optimise your business with complete transparency through dashboards or provide value-added Google Data Studio service to your agency clients.

Make your business transparent

The fastest easy-to-use Google Data Studio dashboards without any recurring cost.