### How to use the Index function to find data?

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc. Open the spreadsheet in WPS Office, select the cells that contain data, and click the Formulas tab.Click Insert Function, input INDEX in search for a function and click OK. 3. In the pop-up dialog box, there are four parameters: array, row number, Column number, and array number. The array requires you to input the data areas. In this case, we want to calcul....

### How to get calculate average

· Option 1: with Quick AccessSelect the cell range filled with the data for calculation.Click Home from the toolbar → AutoSum dropdown button → choose Average · Option 2: with the AVERAGE functionEnter the formula =AVERAGE(Select the cell range filled with the data for calculation.Press Enter to get the average result. WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, etc.

### The COUNTA function in excel

In WPS Spreadsheet, the COUNTA function can help us count the amount of cells left non-empty. · The COUNTA function:=COUNTA(value1, [value2], ...) · Use the COUNTA function for total attendance:In the following example, we use the COUNTA function to calculate total attendance. 1. Enter the formula =COUNTA(C5:C11)2. Press Enter to get the result. As we can see, since 4 cells in total are filled with '√', the result is '4', with the empty cells skipped.Use the COUNTA func....

### How to use the IF function

The IF formula, as one of the most commonly used functions, can determine whether a condition is TRUE or FALSE, so as to get one of the two values. In this article, you will see the explanation of IF function, several examples of IF formula, as well as a case demonstration. · Explanations of IF formula: IF(logical_test, value_if_true, [value_if_false])· logical_test (necessary): the condition to be compared· value_if_true (necessary): the value to be presented as the result when the “....

### How to use the SUM function

· Option 1:1. Select the cell range with data to sum up. 2. Click Formula → AutoSum You can also use the SUM function for multiple rows at the same time. · Option 2: 1. Choose the cell for sum up result.2. Input =SUM(B2:E2) .3. Press Enter on the keyboard.* If you want to get the rest of the results quickly, place the cursor at the down-right corner of F2 until symbol “+” present. Then, change the selected range with the mouse. To be office excel advanced, you could learn how to use W....

### VLOOKUP formula across multiple sheets

In the following example, Sheet1 ‘Client Order List’ records the equipment types ordered by corresponding client company names, while Sheet2 ‘Price List’ lists Sequence No. and Price for each type of equipment. Now we want to fill in Column D ‘Price’ for each company, using the VLOOKUP function with data in Sheet2.Sheet1: Client Order List Sheet2: Price List · Option 1:1. Input =VLOOKUP(B2,'Price List'!$A$1:$C$11,3,FALSE) in cell C2 of Sheet1 ‘Client Order List’. 2. Select cell....