1, "first repeat", "") and other functions."/> 1, "first repeat", "") and other functions.">

Home >Topics >excel >excel basic functions

excel basic functions

尚
Original
2019-06-14 10:29:033213browse

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)

excel basic functions

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)

excel basic functions

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","")

excel basic functions

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","")

excel basic functions

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)

excel basic functions

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

excel basic functions

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn