JD Sartain Use the AutoSum button to calculate basic formulas such as SUM ... First, select a range of blank cells beneath (or on another sheet) that’s the same size as the original range.