### The AND Function in WPS Spreadsheet

02:56*Spreadsheet*51 views

The AND Function in WPS Spreadsheet

### Combine the SUBSTITUTE and LEN functions

02:57*Spreadsheet*156 views

Combine the SUBSTITUTE and LEN functions

### INDEX MATCH formulas

02:11*Spreadsheet*140 views

INDEX MATCH formulas

### Use IFS function to check whether multiple conditions are met

02:47*Spreadsheet*108 views

Use IFS function to check whether multiple conditions are met

### The INDEX function

03:50*Spreadsheet*356 views

The INDEX function

### Use MATCH function to search location information

02:16*Spreadsheet*561 views

Use MATCH function to search location information

### The AVERAGE, MAXIMUM, MINIMUM functions

01:15*Spreadsheet*77 views

The AVERAGE, MAXIMUM, MINIMUM functions

### Use the text function to extract characters in cells

02:45*Spreadsheet*86 views

Use the text function to extract characters in cells

### Elementary arithmetic functions in WPS Spreadsheet

02:50*Spreadsheet*335 views

Elementary arithmetic functions in WPS Spreadsheet

### Efficient statistics with statistical functions

01:48*Spreadsheet*47 views

Efficient statistics with statistical functions

### Create a countdown calendar current time and date

02:14*Spreadsheet*265 views

Create a countdown calendar & Insert current time and date

### Use COUNTIF function for conditional statistics

01:32*Spreadsheet*1,924 views

Use COUNTIF function for conditional statistics

### Use SUM function to quickly calculate the sum

01:31*Spreadsheet*8,824 views

Use SUM function to quickly calculate the sum

### Use IF function to judge data

01:48*Spreadsheet*4,311 views

Use IF function to judge data

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

02:33*Spreadsheet*1,393 views

SUBTOTAL function: Calculate the data with the hidden value

### How to use the Excel MID function

01:54*Spreadsheet*479 views

How to use the MID function in WPS Spreadsheet