Type any value in B3 and c3 cells you will see the answer in the D3 cell. In this example we multiply values in row 1 by the values in row 2 beginning with column B so our formula goes as follows. In Column B we will use a formula to check if the cells in Column C are empty or not.
In the Operation Tools dialog box select the Custom in Operation box enter 385 in the blank.
In this example we multiply values in row 1 by the values in row 2 beginning with column B so our formula goes as follows. Click on the cell where you want the result of the calculation to appear. Sum and then select the desired column either by clicking the column letter at the top of the screen or by using the arrow keys to navigate to the column and using the CTRL SPACE shortcut to select the entire column. This process activates all the functions or formulas of excel.