1704 results for excel subtotal function
- All Tutorials
- Video Tutorials
- Quick Tutorials
- All
- Spreadsheet
- Presentation
- Writer
1704 results for excel subtotal function
SUBTOTAL function: Calculate the data with the hidden value
02:33SUBTOTAL function: Calculate the data with the hidden value
Take this table as an example. When using the SUM function to do summations, we may find two rows hidden in the table, but the result of the summation still includes the hidden value. So how can we calculate the data containing hidden values and get a result that does not include the hidden values? This video can help us and it can be also used in Microsoft Office Excel and Openoffice. In this case, we can use the SUBTOTAL function. Next, we are going to show you the usage of the SUBTO....
Use subtotal feature to do statistic
04:35Use subtotal feature to do statistic
The Subtotal feature of the WPS Spreadsheet is a commonly used feature when processing data. It can automatically statistic the data in the worksheet by fields. So how can we use this feature?Take this table as an example.Before using the subtotal feature, we need to edit the table a little bit. Because when using the subtotal function, we must first sort the fields to be classified, otherwise the result of subtotal may be inconsistent with the expected effect.1. Select any cell in the....
The INDEX function
03:50The INDEX function
The INDEX function can look up a value regarding its row and column numbers.There are two forms of the INDEX function, the Array form and the Reference form. · One: Array formWe'll use the Array form to return the value located in the seventh row and the fourth column.First, select cell J6. Next, click Formulas and then Insert Function to insert the INDEX function. The function syntax:INDEX(array,row_num,column_num)The first parameter, 'Array', refers to the array for valu....
The Trace Precedents function
00:57The Trace Precedents function
WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. While processing a table, we have to double-click a cell containing a function formula to view the referenced data cell, However, this will easily lead to incorrect editing of the formula. At this time, we can use the function of Tracking Precedents of WPS table.Take this table as an example. We want to see which cells are referenced by the formula of ....
The Advanced XLOOKUP Function
08:33The Advanced XLOOKUP Function
What type of lookup function are you using?VLOOKUP? HLOOKUP? Or...King of the Lookup function-XLOOKUP function is available now!With the XLOOKUP function, you can search for a match in a range or array and return the corresponding item through the second range or array.· The powerful lookup functionSuppose we want to look up Rico's department.Enter=XLOOKUP, and press the TAB key. We need to answer three questions for mandatory arguments.1, what is the keyword for lookup values?Ente....
Use CONCAT function to merge data
01:16Use CONCAT function to merge data
We can use the CONCAT function to merge the contents of multiple cells.This function is mainly applied to merge character strings within a certain cell range or in different cells. Now we take a simple case as an example. We want to merge the domain names to form a complete website address.1. Click Formulas, click Insert Function, input "CONCAT" in the dialog, and click OK.2. Since the cells to be combined are continuous, we input "A2:D2" in Text 1, click OK, and drag the cell to fill ....
Look up data quickly with LOOKUP function
04:23Look up data quickly with LOOKUP function
Today I would like to introduce you to the LOOKUP function, which has many relevant knowledge points. Beginners will have some difficulty in learning the LOOKUP function, and the video will introduce the common use of this function and the notes in the process of using it. Take this spreadsheet as an example. If we want to find out who is the purchaser based on the lump sum in cell J9, we can use the LOOKUP function. The general statement structure of the LOOKUP function is LOOKUP (Loo....
AVERAGE function quickly average data
00:57AVERAGE function quickly average data
In WPS Spreadsheet, we can use the AVERAGE function to quickly find the average value of a set of data quickly. It is often used to calculate average wages, average sales, and so on. Take this table as an example. We now need to find the average sales of the bakery this week. After we click cell D4, click Insert Function, and enter AVERAGE in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up. The data we filled in Num....