=SUM(C1:C12) is the correct Excel formula to sum all values from cell C1 to C12.
The colon : denotes a continuous range of cells.
Get instant updates and alerts directly from our site.
Install this app on your device for quick access right from your home screen.