What should I do if the automatic sum of vertical columns in Excel is 0?

#What should I do if the automatic sum of vertical columns in excel is 0?

Solution to automatically sum the vertical columns of Excel to 0:

First, we open Excel and find the file we need to process. We have the following picture: example. For a certain food distributor, we know the sales quantity and damage quantity of several types of food, and now we need to find the purchase quantity of each type of food. Then we first select the column with the purchase quantity with the mouse.

Then, everyone enters the formula in the table, that is, enter "=B2 D2" in cell E2. The Chinese formula is [input = in the cell where it is located, then click the mouse on the cell and then click on the quantity cell]. Of course, you can also click directly with the mouse as described in the formula, which is more convenient.

Next, press the [Enter key] to get the sales data. Place the mouse on the table. When the arrow changes to a symbol, drag it to the last position of the column. Bit. Parameters can be numbers, text, logical values ​​in the form of TRUE or FALSE, arrays, error values ​​in the form of #N/A, or cell references. The given parameters must produce valid values. Parameters can also be constants, formulas, or other functions.

Finally, after everyone is done, find the location that needs to be saved and store it. Parameters are not just constants, formulas, or functions, they can also be arrays, cell references, etc.

Recommended tutorial: "excel basic tutorial"

The above is the detailed content of What should I do if the automatic sum of vertical columns in Excel is 0?. For more information, please follow other related articles on the PHP Chinese website!