Google Sheets - Various Ways to Average
Getting averages of data in a Google spreadsheet is easier than ever. But did you know there are different ways to average which let you handle all kinds of situations? Let's start with the basic and work from there... Method #1 : Viewing the Average with the Quick Menu If you highlight any range of cells on your spreadsheet, you can quickly get the average by clicking on the drop-down menu in the bottom right corner - it probably says Sum: by default, but clicking on it you can change it to Ave: - to get the average of the selected cells. A very quick way to see the average, the drawback is that it is not on your spreadsheet so if you have other formulas that need to use the average it isn't a value on your spreadsheet. Method #2 : Using the Average Formula In any empty cell on your spreadsheet, you can use the =AVERAGE formula. It is a formula that only has 1 criterion - the range of cells to use in calculating the average. If they are not cons...