In this post, we take a look at How to Use AVERAGE Function in Google Sheets. Previously we looked at the ROUND function in google sheets. Which was kind of used in most of the calculations and the financial calculations where the rounding of number was expected. So in that context you can see that the function AVERAGE is next in the line for some of the similar operations specific to the financial usage.
For this tutorial, you can check out the usage of the AVERAGE function which we can find out the average with large data set. And the data set that we often use when it comes to the finding the relative specific value that would help us with the average value in the spreadsheet. In that context itself you can use most of the financial transactions like say you want to find out yearly sum of specific items with average. You can use the formula in that case there.
Let's take a look at one of the tutorial where you can learn how to use AVERAGE function in Google Sheets.
Let's first start with the blank spreadsheet in the Google Sheets. The next step would be taking some sort of the fake data you can use variety of the apps out there to make that or you can even take the below fake data that you may find useful for your use case there.
value
2
-1
11
Google
TRUE
FALSE
You can see the formula to now make the average of this data.
And on that note you can make use of the formula below to filter out and bring the average of that data in such case it would help you with the results there.
=AVERAGE(A2:A4)
This is just one use case imagine you can add more data specific to the finance and you can find out the average of the multiple set of the values. And that would be a good option for you to work around with as well. I have learned that those who want to make the financial statements also make use of the average function often that would be giving them some results. This in turn can show you how we can work around with the variety of the cells and combine them for the value too.
So the basic formula for the AVERAGE works something like this:
=AVERAGE(value1, [value2, …])
You can use this in variety of ways. Like say you can find the range through which you can find the average. And another point is that you can also have specific set of the cells that you can use for finding the average. That also works out. You can then also find the average across all when you are dealing with multiple type of the cells and the overall range. So that is one more way for you tofind out the value for the average function. Something like this can be done with variety of the calculations that you can do in this case as well.
You can use set of cells in multiple ways. You can also make use of the set of the adjacent cells that you can use for the calculation in this case. A lot of interesting calculations can be done here. You can also explore the function named AVERAGEIF. These are some of the functions that you can use for the working with the finding the average values from the data that is out there. You can also use the median but more accurate function would be the average. So that kind of gives you an idea on when to use which functon for yourself and it would be pretty cool to try out.
Next function which I wish to cover is the GOOGLEFINANCE function which would make it easier for you to work with the content specific from the web that google fetches for the finance.And that in itself is going to be pretty cool for the values that you are about to get through this function.I would say that those who wish to keep track those function can make use of it and then you can get a lot of content properly sorted in the due time there. This is the type of roadmap I am in process of building because it would cover variety of spreadsheet tutorials.
I have been making the tutorials in the space of the spreadsheet and have managed to make the good amount of coverage on the Coda, Google Sheets, Notion and other KM based tutorial.So there are lot of things I have yet to cover and will be covering over a period of time.I hope that you subscribe to my channel through the video given above and then also comment or share across your network. That would definitely help me bring some value to the table. It can be a good thing if you ask me as I need the views on the videos there.
I'll add more spreadsheet tutorial by the next week. :)