The SUM function is the most basic and most used formula in Excel.
Using SUM
Instead of typing =A1+A2+A3, simply type =SUM(A1:A100) to add up every single number in that entire range instantly. You can also sum multiple ranges: =SUM(A1:A10, C1:C10).