### Use MATCH function to search location information

02:16*Spreadsheet*9 views

Use MATCH function to search location information

### The AVERAGE, MAXIMUM, MINIMUM functions

01:15*Spreadsheet*10 views

The AVERAGE, MAXIMUM, MINIMUM functions

### Elementary arithmetic functions in WPS Spreadsheet

02:50*Spreadsheet*9 views

Elementary arithmetic functions in WPS Spreadsheet

### Efficient statistics with statistical functions

01:48*Spreadsheet*16 views

Efficient statistics with statistical functions

### Create a countdown calendar current time and date

02:14*Spreadsheet*26 views

Create a countdown calendar current time and date

### Use COUNTIF function for conditional statistics

01:32*Spreadsheet*190 views

Use COUNTIF function for conditional statistics

### Use SUM function to quickly calculate the sum

01:31*Spreadsheet*2,055 views

Use SUM function to quickly calculate the sum

### Use IF function to judge data

01:48*Spreadsheet*1,010 views

Use IF function to judge data

### SUBTOTAL function: Calculate the data including or ignoring the hidden value

02:33*Spreadsheet*344 views

SUBTOTAL function: Calculate the data with the hidden value

### How to use the Excel MID function

01:54*Spreadsheet*105 views

How to use the Excel MID function

### Use COUNT function to count the number of cells with parameters

01:20*Spreadsheet*304 views

Use COUNT function to count the number of cells with parameters

### Use the DATEDIF function to calculate the intervals of dates

03:12*Spreadsheet*453 views

Use the DATEDIF function to calculate the intervals of dates

### AVERAGE function quickly average data

00:57*Spreadsheet*524 views

AVERAGE function quickly average data

### Use SUMIFS function with multiple criteria

02:27*Spreadsheet*217 views

Use SUMIFS function with multiple criteria

### COUNTIFS function: count data of multiple criteria

01:57*Spreadsheet*228 views

COUNTIFS function: count data of multiple criteria

### TEXT formula in Excel

03:09*Spreadsheet*261 views

TEXT formula in WPS Spreadsheet