How to Sum a Column in Excel

{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Sum a Column in Excel", "description": "Want to add up a column in Excel? Follow these quick steps using the SUM formula or AutoSum to total values in just a few clicks.", "step": [ { "@type": "HowToStep", "name": "Select an empty cell beneath your column", "text": "Open your sheet in Excel, then scroll to the bottom of the column that you want to total and click into the first empty cell beneath the values." }, { "@type": "HowToStep", "name": "Use the SUM formula", "text": "Type a formula like =SUM(A2:A31) to total the range from the first to last cell in the column you want to add, and then hit Return (Mac) or Enter (Windows)." }, { "@type": "HowToStep", "name": "Use AutoSum as a shortcut", "text": "Alternately, you can skip writing a formula. Click an empty cell, go to the Home tab, and click the AutoSum (∑) button to automatically insert the correct formula for the column above." } ] }