Open Google Sheets, and select a cell.
Enter the equal sign (=).
bang out a number.
Lifewire / Maddy Price
Enter the asterisk (*) to signify multiplication.
key in the second number.
PressEnterto see the result.
The best way is to use cell references.
Cell references are variables that hold the data in the cells they reference.
Cell Reference Advantages
Cell references identify the location of the data used in a formula.
Using cell references rather than the actual data in a formula has benefits.
The results of the formula update automatically when the data changes.
Multiplication Formula Example
Working with cell references isn’t much different than working with regular numbers.
To follow along with this tutorial, enter the data shown in the image below.
Selectcell C2to make it theactive cellthis is where the results of the formula will display.
key in anequal sign(=).
Selectcell A2to enter that cell reference into the formula.
Or, typeA2, if you prefer.
jot down anasterisk symbol(*).
Selectcell B2to enter that cell reference.
Press theEnterkey on the keyboard to complete the formula.
The answer appears in cell C2.
Selectcell C2to display the formula=A2*B2in theformula barabove the worksheet.
The answer in cell C2 automatically updates to reflect the change in data in cell A2.
opt for cell that contains the formula.
In this example, selectcell C2.
PressCtrl+Con Windows orCommand+Con Mac to copy the data in the cell.
PressCtrl+Von Windows orCommand+Von Mac to paste the formula in the highlighted cells.
The highlighted cells fill with multiplication results from the formula.
Next, selectFunctions>SUMand then pick the individual cells with numbers you want to add up.
