After excel filtering, I want to count how many rows are filtered out, how to count?

Place the cursor on the first line, then press the shift key to pull to the last line.

There's a number of items in the bottom right corner, just look at that.

I don't know if it meets your requirements.

subtotal(103,a1:a1000)

Or in the lower-left corner, it shows how many records are filtered out.

The specific steps to see the number of filters after using filtering in excel are as follows:

The materials we need to prepare are: computer, excel**.

1. First of all, we open the required excel** and select the data to be filtered.

2. Then we click on the start submenu bar and select "Filter".

3. Then after we filter out the data we want, we can see that the count is 19 in the lower right corner of the page, which means that 19 data are filtered out.

How does <> excel filter out the display quantity? Check it out.

Material tools.

excel**。Method.

Open Excel.

Please click Enter a description.

Create a text data**.

Please click Enter a description.

In cell A14, enter the function =COUNTA(A2:A9) and press Enter.

Please click Enter a description.

Enter =subtotal(3,a2:a9) in cell A15, and 3 represents the counting number.

Please click Enter a description.

Select Chinese and click on the data above, and click on Filter.

Please click Enter a description.

Click on the gender filter to cancel the data for male.

Please click Enter a description.

At this time, you will see that the subtotal function counts the filtered data.

Please click Enter a description.

How to count the number of rows after excel filtering:

Tools Raw materials.

win10 system computer office2010

1. Find and open the Excel software spinal on the computer desktop to find the data that needs to be carried out.

2. Select cell G2 in the worksheet, type "=mod(row(),2)" in the address bar, and pull the result down to G13.

3. Select the G2 cell, right-click, select "Filter" after the pop-up menu, and select "Filter by the value of the selected cell" in the pop-up submenu.

4. After the filter dialog box pops up, find the number "1" below the number filter and check it in front of it.

5. Select the "A3:F13" cell in the Wild area, find "Sheet2" in the bottom corner of the software homepage, click Copy, and the odd row sub-table is completed.

6. Repeat the third step, but check the number 0 before it, select the even row of data, and copy it to sheet2.

1. Open Excel** on the computer, and then select a column of data ctrl+shift+l to filter.

2. After filtering a list of data, enter the formula =subtotal(3,b3:b6). Vertical fluid.

3. After entering Gongchang Xianming =subtotal(3,b3:b6), press enter to get the number of filtered rows.

First, open the Excel document; Select the data region you want to filter and click Data - Auto Filter. After filtering a column of data, enter the formula =subtotal(3,b3:b6); After entering the formula, press enter to get the filtered number of rows.

Four super practical tips in Excel:

1. After selecting the area, use the shortcut key alt+= to sum the auspicious key.

2. Circle the row that needs to be hidden, press the shortcut key Ctrl+9 to quickly hide, and press Ctrl+Shift+9 to unhide. Eggplant.

3. When the values are confused, click Sort and Filter in the upper right corner to sort the data in ascending and descending order.

4. Turn on the filter function in the Sort and filter in the upper right corner, and you can filter out the data you need in the list.

Material Tools: Excel2010

1. Open Excel 2010 and enter the ranking table as shown in the figure.

2. Select cell G2, enter =mod(row(),2), as a condition for determining odd and even rows, and pull down to g13.

3. Press and hold the G2 cell, right-click - filter the leak - filter by the value of the selected cell.

4. Put a tick in front of the number "1" and select an odd number of rows of data.

5. Select A3:F13, press "Ctrl+V" to destroy the cavity, and click Sheet2 in the lower left corner of the page to copy, so as to form a ranking table with odd rows.

6. Repeat step 3, but tick the number "0" in front of it, select the even row of data, and copy it to sheet2 to connect it with the data in the previous step to complete the intended purpose!

1. Open Excel**, and then select the cell area that needs to be filtered for statistical quantity.

2. Then click the "Insert" option in the toolbar above and select the "Pivot Table".

3. Drag the "Data" column into the "Filter" box, and drag the "Data" column into the "Value" box.

4. Click the "Data" drop-down box, click the value to be filtered, and click OK.

5. The cells can be filtered, and the filtered values will be calculated into statistical quantities.