# How to Calculate Sales of Produce in Excel

Keeping track of and calculating the sales of different types of produce on paper can be time-consuming. You can simplify this process by using a Microsoft Excel spreadsheet to record your sales data in rows and columns. You can create formulas that will calculate your sales for each type of produce and your sales of all produce, based on the amount of each type of produce you sold and the price per pound at which you sold it. This can help you store and analyze your sales data.

#### 1

Determine the types of produce you sold, the price per pound at which you sold them, and the number of pounds you sold of each type. For example, assume you sold 40 pounds of apples at $1 per pound and 50 pounds of bananas at $1.25 per pound.

#### 2

Click in cell A1 in a blank Excel worksheet. Type the name of the first produce you sold and press "Enter." Type the name of each additional produce one cell below the previous produce. Press "Enter" after typing in each cell. In the example, click in cell A1, type "Apples" and press "Enter." Then type "Bananas" in cell A2 and press "Enter."

#### 3

Click in cell B1. Type the price per pound of the first produce and press "Enter." Type the price per pound of each additional produce one cell below the previous produce. Press "Enter" after typing in each cell. In the example, click in cell B1, type "$1" and press "Enter." Then type "$1.25" in cell B2 and press "Enter."

#### 4

Click in cell C1. Type the number of pounds you sold of the first produce and press "Enter." Type the number of pounds you sold of each additional produce one cell below the previous produce. Press "Enter" after typing in each cell. In the example, type "40" in cell C1 and press "Enter." Then type "50" in cell C2 and press "Enter."

#### 5

Click in cell D1, type the formula "=B1*C1" and press "Enter" to calculate the sales you generated from the first produce. Excel multiplies the price per pound in cell B1 by the number of pounds sold in cell C1. In the example, you get $40 in cell D1.

#### 6

Click in cell D1. Hold the "Ctrl" key and press "C" to copy the formula in cell D1. Then click in cell D2. Hold "Ctrl" and press "V" to paste the copied formula into cell D2. In the example, Excel automatically adjusts the formula to multiply cell B2 by cell C2 to get $63 in cell D2. If you have additional rows of information, click in additional cells in the "D" column, hold "Ctrl" and press "V" to paste the formula.

#### 7

Click in cell D3, type the formula "=SUM(D1:D2)" and press "Enter." Excel calculates the su of the sales amounts in the range of cells from D1 to D2. If you have additional rows of information, replace "D2" in the formula with the last cell in the "D" column that contains your produce sales information. In the example, Excel calculates the sum of $40 in cell D1 and $63 in cell D2 to get a total produce sales amount of $103.