excel basic functions

Commonly used functions in Excel are: =SUM(B2:F2), =AVERAGE(G2:G7), =IF(COUNTIF(A:A,A2)>1," Same",""), =IF(COUNTIF(A2:A99,A2)>1," First repeat",""), =AVERAGEIF(B2:B7,"Male",C2:C7), =SUMPRODUCT( (B$2:B$7>B2)/COUNTIF(B$2:B$7,B$2:B$7)) 1 and so on.

The specific usage is as follows:

1. Calculate the sum of data: =SUM(B2:F2)

2. Calculate the overall average value of the table (Note: The position of the function table must be adjusted according to the actual situation)

Function: =AVERAGE(G2:G7)

3. Find the same values ​​in the table (note: the table coordinates in the function must be adjusted according to the actual table coordinates)

Function: =IF(COUNTIF(A:A,A2)>1,"Same","")

4. Calculate the number of non-duplicate tables (Note: the table coordinates in the function must be adjusted according to the actual table coordinates)

Function: =IF(COUNTIF (A2:A99,A2)>1,"First repetition","")

5. Calculate the overall average score of the boys table (note: table coordinates in the function , need to be adjusted according to the actual table coordinates)

Function: =AVERAGEIF(B2:B7,"Male",C2:C7)

6. Calculate Score ranking (note: the table coordinates in the function must be adjusted according to the actual table coordinates)

Function: =SUMPRODUCT((B$2:B$7>B2)/COUNTIF(B$2:B$7,B$2: B$7)) 1

For more Excel-related technical articles, please visit the Excel Basic Tutorial column!

The above is the detailed content of excel basic functions. For more information, please follow other related articles on the PHP Chinese website!