In this case we entered sum then selected the Qtr 1 and Qtr 2 columns. Type the formula that you want to use and press Enter. 3 sum all of row 3.
In the Operation Tools dialog box select the Custom in Operation box enter 385 in the blank.
Just make sure that the formula is placed first on the cell of the column or the row you want to use. 2 click AutoFill Handle down to the bottom in column C. Select the column or row that you will work with in this case select the Column A and click Kutools More. Position the cursor to the lower right corner of the cell with the formula wait until it turns into the plus sign and then double-click the plus.