Use SUM function to quickly calculate the sum

Use SUM function to quickly calculate the sum

01:31
icon Spreadsheet 2,375 views
Use SUM function to quickly calculate the sum
Use IF function to judge data

Use IF function to judge data

01:48
icon Spreadsheet 1,181 views
Use IF function to judge data
A quick way to calculate sum, average, count, max, and min

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

01:34
icon Spreadsheet 1,090 views
A quick way to calculate sum, average, count, max, and min
Use Date function to convert date format

Use Date function to convert date format

01:50
icon Spreadsheet 762 views
Use Date function to convert date format
AVERAGE function quickly average data

AVERAGE function quickly average data

00:57
icon Spreadsheet 617 views
AVERAGE function quickly average data
Use the DATEDIF function to calculate the intervals of dates

Use the DATEDIF function to calculate the intervals of dates

03:12
icon Spreadsheet 525 views
Use the DATEDIF function to calculate the intervals of dates
Use the Today function to quickly calculate days between dates

Use the Today function to quickly calculate days between dates

01:57
icon Spreadsheet 426 views
Use the Today function to quickly calculate days between dates
SUBTOTAL function: Calculate the data with the hidden value

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

02:33
icon Spreadsheet 375 views
SUBTOTAL function: Calculate the data with the hidden value
Use COUNT function to count the number of cells with parameters

Use COUNT function to count the number of cells with parameters

01:20
icon Spreadsheet 369 views
Use COUNT function to count the number of cells with parameters
TEXT formula in WPS Spreadsheet

TEXT formula in Excel

03:09
icon Spreadsheet 310 views
TEXT formula in WPS Spreadsheet
Use the ROUND function to round decimals quickly 

Use the ROUND function to round decimals quickly 

01:57
icon Spreadsheet 303 views
Use the ROUND function to round decimals quickly 
Use COUNTIF function for conditional statistics

Use COUNTIF function for conditional statistics

01:32
icon Spreadsheet 268 views
Use COUNTIF function for conditional statistics
Look up data quickly with LOOKUP function

Look up data quickly with LOOKUP function

04:23
icon Spreadsheet 258 views
Look up data quickly with LOOKUP function
COUNTIFS function: count data of multiple criteria

COUNTIFS function: count data of multiple criteria

01:57
icon Spreadsheet 256 views
COUNTIFS function: count data of multiple criteria
Use SUMIFS function with multiple criteria

Use SUMIFS function with multiple criteria

02:27
icon Spreadsheet 242 views
Use SUMIFS function with multiple criteria
The SUMPRODUCT function for quick calculation of total sales

The SUMPRODUCT function for quick calculation of total sales

01:44
icon Spreadsheet 131 views
The SUMPRODUCT function for quick calculation of total sales