WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1704 results for excel subtotal function

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        1704 results for excel subtotal function

        SUBTOTAL function: Calculate the data with the hidden value

        SUBTOTAL function: Calculate the data with the hidden value

        02:33

        SUBTOTAL 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....

        Spreadsheet 23.9K views
        Use subtotal feature to do statistic

        Use subtotal feature to do statistic

        04:35

        Use 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....

        Spreadsheet 9.3K views
        The INDEX function

        The INDEX function

        03:50

        The 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....

        Spreadsheet 13.9K views
        The Trace Precedents function

        The Trace Precedents function

        00:57

        The 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 ....

        Spreadsheet 5.9K views
        The Advanced XLOOKUP Function

        The Advanced XLOOKUP Function

        08:33

        The 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....

        Spreadsheet 13.4K views
        Use CONCAT function to merge data

        Use CONCAT function to merge data

        01:16

        Use 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 ....

        Spreadsheet 18.7K views
        Look up data quickly with LOOKUP function

        Look up data quickly with LOOKUP function

        04:23

        Look 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....

        Spreadsheet 17.1K views
        AVERAGE function quickly average data

        AVERAGE function quickly average data

        00:57

        AVERAGE 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....

        Spreadsheet 33.1K views
        Prev 1 2 3 ... 212 213 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube