# How to Calculate the Average in Google Sheets

Viewport: 1920x950 @0.800000011920929x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Calculate the Average in Google Sheets
   - body: This detailed guide will walk you through the process of calculating the average of a range of numbers in Google Sheets. Follow the steps below to efficiently compute the average value for your data set.
   - voiceover: This guide provides a detailed walkthrough on how to calculate the average of a range of cells in Google Sheets. Follow these simple steps to quickly and accurately find the average value of your selected data.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi7l4t00190cl21rul1qma.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the cells you want
   - source type: IMAGE
   - description: Open Google Sheets
   - target: (213, 195), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - hotspots: 1
     - hotspot_01 (213, 195), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Click and drag your mouse to highlight all the cells containing the data for which you want to calculate the average. Ensure all desired cells are selected before proceeding.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi7pzz001b0cl2b1y1b7rv.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi3vt40000033p4lv3w0pa.png
2. step_02 [image] - Click on Functions option
   - source type: IMAGE
   - description: Select the Range of Cells
   - target: (1258.6950242018986, 73.0000036338072), rect: top=71.23046875 left=1326.89453125 width=22.98828125 height=28.0078125
   - hotspots: 1
     - hotspot_01 (1258.6950242018986, 73.0000036338072), rect: top=71.23046875 left=1326.89453125 width=22.98828125 height=28.0078125
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: Navigate to the menu bar above your spreadsheet. Click on the 'Functions' button, typically represented by a sigma (Σ) symbol. This will open a dropdown menu with various functions.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi7q1i001c0cl2clpi79lj.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi40wa0002033pgome7yhn.png
3. step_03 [image] - Click on AVERAGE formula
   - source type: IMAGE
   - description: Navigate to Functions
   - target: (1264.6160865190564, 143.47178989869624), rect: top=145.21484375 left=1338.3984375 width=167.98828125 height=20
   - hotspots: 1
     - hotspot_01 (1264.6160865190564, 143.47178989869624), rect: top=145.21484375 left=1338.3984375 width=167.98828125 height=20
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: In the dropdown menu, scroll down and click on the 'AVERAGE' option. This function will calculate the mean of the selected cells.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi7q28001d0cl2et3m53ew.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi42nq0003033pv806ugv3.png
4. step_04 [video] - Click here
   - source type: VIDEO
   - target: (253, 690), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - hotspots: 1
     - hotspot_01 (253, 690), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - clip: start=9.307 end=14.464 duration=5.157
   - video: url=https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi3s42004m0cjv7com9bbi.webm speed=1 muted=true
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi3s42004m0cjv7com9bbi.webm
5. step_05 [image] - The average will be calculated in the cell
   - source type: IMAGE
   - description: Choose AVERAGE Function
   - target: (275.1311237789005, 678.9344179746214), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - hotspots: 1
     - hotspot_01 (275.1311237789005, 678.9344179746214), rect: top=166.93359375 left=75 width=2312.98828125 height=970.99609375
   - dimensions: 1920x950 @0.800000011920929x
   - layout: 1 (full)
   - voiceover: After selecting the 'AVERAGE' function, the average value of the highlighted cells will be automatically calculated and displayed in a new cell. The result will be visible immediately.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi7q34001e0cl209cnbjcv.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi47820005033pub35q7m7.png
7. [Outro] Next Steps
   - body: After selecting the AVERAGE function, Google Sheets will prompt you to finalize the range. Confirm the range and press Enter to see the calculated average. For more complex data analysis, consider exploring additional functions available in Google Sheets.
   - voiceover: You have successfully calculated the average of your selected cells. For further analysis, you might want to explore other functions available in Google Sheets, such as SUM, MAX, or MIN.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6hi3s2m0049jv0ck1b7aloj/cm6hi7nlr001a0cl2fbddguou.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6hi3s2m0049jv0ck1b7aloj/tour