Fortune telling fruit excel_ How many fortune telling fruits do you have?

How does excel automatically calculate the total?

You can use the Sumif function in Excel to calculate the total automatically.

The following example illustrates in detail how to use sumif function to calculate the total number of fruits in a topic. Among them, column A, column B and column C put the original data, column E is the type of fruit, and column F calculates the total number of fruits.

1, enter the original data. Click on column A, column B and column C to input the original data, and click on column E to input the original values respectively.

2. Calculate the total number of bananas. Select cell F2 and enter the formula =SUMIF(B:B, E2, C:C).

3. Calculate the total number of other fruits. Select cell F2, move the mouse to the lower right corner of cell F2, and when the mouse becomes "+",drop it down to F4.

4. After adding data in column A, column B and column C, column F will automatically calculate the corresponding total number of fruits.

SUMIF function is commonly used in Excel. Use? SUMIF？ Function can sum the values within the report range that meet the specified conditions. Sumif function is used in Excel to add multiple cells, ranges or references according to specified conditions.

The syntax of sumif function is: SUMIF(range, criteria, sum_range).

The parameters of the sumif function are as follows:

The first parameter: Range is a conditional area, which is a cell area used for conditional judgment.

The second parameter: Criteria is a summation condition and a judgment condition consisting of numbers and logical expressions.

The third parameter: Sum_range is the actual summation area, the cell, range or reference that needs summation.

When the third parameter is omitted, the conditional region is the actual summation region.

Baidu encyclopedia -SUMIF function