Sum in Excel If you like to find the sum of your data in rows in your spreadsheet, you may use following formula. =Sum (A1:A3). AutoSum: Without using formula we can also calculate the sum using "AutoSum" option in "Formulas" tab. My notes images: