Hold Control Key and Drag your mouse to select two ranges Click the Formulas tab. Click the AutoSum button. Check the result.