### Look up data quickly with LOOKUP function

04:23*Spreadsheet*232 views

Look up data quickly with LOOKUP function

### Use SUM function to quickly calculate the sum

01:31*Spreadsheet*2,150 views

Use SUM function to quickly calculate the sum

### Use IF function to judge data

01:48*Spreadsheet*1,042 views

Use IF function to judge data

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

01:34*Spreadsheet*972 views

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

### Use Date function to convert date format

01:50*Spreadsheet*684 views

Use Date function to convert date format

### AVERAGE function quickly average data

00:57*Spreadsheet*546 views

AVERAGE function quickly average data

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

03:12*Spreadsheet*481 views

Use the DATEDIF function to calculate the intervals of dates

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

01:57*Spreadsheet*398 views

Use the Today function to quickly calculate days between dates

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

02:33*Spreadsheet*351 views

SUBTOTAL function: Calculate the data with the hidden value

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

01:20*Spreadsheet*325 views

Use COUNT function to count the number of cells with parameters

### TEXT formula in Excel

03:09*Spreadsheet*280 views

TEXT formula in WPS Spreadsheet

### Use the ROUND function to round decimals quickly

01:57*Spreadsheet*266 views

Use the ROUND function to round decimals quickly

### COUNTIFS function: count data of multiple criteria

01:57*Spreadsheet*234 views

COUNTIFS function: count data of multiple criteria

### Use SUMIFS function with multiple criteria

02:27*Spreadsheet*225 views

Use SUMIFS function with multiple criteria

### Use COUNTIF function for conditional statistics

01:32*Spreadsheet*208 views

Use COUNTIF function for conditional statistics

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

01:44*Spreadsheet*111 views

The SUMPRODUCT function for quick calculation of total sales