How to Calculate Total Sales Amount in Microsoft Excel 2019 - Methods to Calculate Total Sales Amount

Time: 2022-02-23Source: Huajun Software TutorialAuthor: blue thin mushroom

Many people don’t know how to calculate the total sales amount in Microsoft Excel 2019? The article brought to you today is Microsoft Excel If you still don’t know the method of calculating the total sales amount in 2019, let’s learn it with the editor.

Step 1: First, we open Excel and find the cell where we want to calculate the total amount (as shown in the picture).


Step 2: We type "=" to start the calculation and select the unit price cell (as shown in the figure).


Step 3: Type the symbol of the product and select the sales volume cell (as shown in the picture).



Step 4: Press the Enter key and press Enter. The result of the product will appear (as shown in the picture).


Step 5: In order to facilitate the calculation of other cells, we select cell C2, move the mouse to the lower right corner of the cell, a cross "cross" mark appears, and we pull down to all cells that need to be calculated (as shown in the picture).



The above is the entire content of how to calculate the total sales amount in Microsoft Excel 2019 brought to you by the editor. I hope it can help you.

Related articles更多>>

Popular recommendations