# How to Sum a Column in Google Sheets

Viewport: 1920x951 @0.75x

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

1. [Intro] How to Sum a Column in Google Sheets
   - body: This guide provides a detailed walkthrough on how to sum a column in Google Sheets. Follow these steps one by one to easily compute the sum of values in any column.
   - voiceover: This guide will walk you through the process of summing a column in Google Sheets step-by-step. The steps provided will help you quickly and effectively calculate the total of any column in your spreadsheet.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdwqcu000b0cjua28i6dx1.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Select the column you want
   - source type: IMAGE
   - description: Open Google Sheets and select your spreadsheet
   - target: (169, 198), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (169, 198), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Click on the letter at the top of the column you want to sum to select the entire column.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdx034000d0cju8acx9152.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdoxh10003033pbl1frjpo.png
2. step_02 [video] - Click here
   - source type: VIDEO
   - target: (178, 816), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (178, 816), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - clip: start=2.346 end=5.55 duration=3.2039999999999997
   - video: url=https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdos23000w0dl17l60acje.webm speed=1 muted=true
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdos23000w0dl17l60acje.webm
3. step_03 [image] - Click on the Functions icon
   - source type: IMAGE
   - description: Click on the cell where you want the sum to appear
   - target: (1286.4917409495886, 67.08197183829802), rect: top=71.33333587646484 left=1333.5 width=23 height=28
   - hotspots: 1
     - hotspot_01 (1286.4917409495886, 67.08197183829802), rect: top=71.33333587646484 left=1333.5 width=23 height=28
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the toolbar at the top of the screen, locate and click on the Functions icon, which looks like the Greek letter sigma (Σ).
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdx04g000e0cjuee2s9dqb.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdp0es0007033p57x5uuea.png
4. step_04 [image] - Click SUM
   - source type: IMAGE
   - description: Enter the formula '=SUM('
   - target: (1283.6987331994783, 117.99998395861269), rect: top=114.33333587646484 left=1345 width=168 height=20
   - hotspots: 1
     - hotspot_01 (1283.6987331994783, 117.99998395861269), rect: top=114.33333587646484 left=1345 width=168 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: From the drop-down menu that appears after clicking the Functions icon, select the 'SUM' function to calculate the total of the selected column.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdx05s000f0cjufj1daq6r.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdp1aj0008033puhju6mhn.png
5. step_05 [image] - The sum will be displayed at the bottom of the column
   - source type: IMAGE
   - description: Press Enter to display the sum
   - target: (257.66625294487227, 821.727686743799), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - hotspots: 1
     - hotspot_01 (257.66625294487227, 821.727686743799), rect: top=167.33334350585938 left=47 width=2501 height=1051
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: The sum of the selected column will be displayed at the bottom of the column in the cell just below the last row of data.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdx08z000g0cju1biv8gf3.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdp7vl000a033p43ktnzuv.png
7. [Outro] Next Steps
   - body: You have successfully summed a column in Google Sheets. For more advanced operations, explore other formulas and functions available in Google Sheets.
   - voiceover: You have successfully summed a column in Google Sheets. You can now use this total in other calculations or analyses as needed.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6fdos0l001ll10dueyy6lte/cm6fdwxjb000c0cju917za2m1.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

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