### Look up data quickly with LOOKUP function

04:23*Spreadsheet*1,024 views

Look up data quickly with LOOKUP function

### Use SUM function to quickly calculate the sum

01:31*Spreadsheet*8,811 views

Use SUM function to quickly calculate the sum

### A quick way to calculate Sum, Average, Count, Max, and Min in WPS Spreadsheet

01:34*Spreadsheet*4,332 views

A quick way to calculate sum, average, count, max, and min

### Use IF function to judge data

01:48*Spreadsheet*4,302 views

Use IF function to judge data

### Use Date function to convert date format

01:51*Spreadsheet*2,878 views

Use Date function to convert date format

### AVERAGE function quickly average data

00:57*Spreadsheet*2,343 views

AVERAGE function quickly average data

### Use COUNTIF function for conditional statistics

01:32*Spreadsheet*1,917 views

Use COUNTIF function for conditional statistics

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

03:12*Spreadsheet*1,784 views

Use the DATEDIF function to calculate the intervals of dates

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

01:20*Spreadsheet*1,634 views

Use COUNT function to count the number of cells with parameters

### Use the Today function to quickly calculate days between dates

01:57*Spreadsheet*1,575 views

Use the Today function to quickly calculate days between dates

### TEXT formula in Excel

03:09*Spreadsheet*1,443 views

TEXT formula in WPS Spreadsheet

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

02:33*Spreadsheet*1,389 views

SUBTOTAL function: Calculate the data with the hidden value

### Use the ROUND function to round decimals quickly

01:57*Spreadsheet*1,224 views

Use the ROUND function to round decimals quickly

### Use SUMIFS function with multiple criteria

02:27*Spreadsheet*1,076 views

Use SUMIFS function with multiple criteria

### COUNTIFS function: count data of multiple criteria

01:57*Spreadsheet*996 views

COUNTIFS function: count data of multiple criteria

### The SUMPRODUCT function for quick calculation of total sales

01:44*Spreadsheet*624 views

The SUMPRODUCT function for quick calculation of total sales