excel中去重计数
There are lots of different ways to count things in Excel – maybe you need to count the numbers in a column, or all the data, or just the blank cells. Fortunately, there is a function for each of those:
在Excel中,有很多不同的方法可以对事物进行计数 –也许您需要对列中的数字,所有数据或仅空白单元格进行计数。 幸运的是,每个功能都有一个功能:
- COUNT 计数
- COUNTA COUNTA
- COUNTBLANK 空白
For example, to count the blank cells in the range A1:A5, use the following formula in cell A7:
例如,要计算范围A1:A5中的空白单元格,请在单元格A7中使用以下公式:
=COUNTBLANK(A1:A5)
= COUNTBLANK(A1:A5)
更复杂的计数 (More Complicated Counting)
If you have more complicated things that you need to count, there are other functions to do the job:
如果您需要处理更复杂的事情,还有其他功能可以完成:
- COUNTIF COUNTIF
- COUNTIFS COUNTIFS
- SUBTOTAL 小计
- AGGREGATE 骨料
For example, to count only the visible numbers, after filtering and/or manually hiding rows in a list, use a SUBTOTAL formula. This example uses 102 as the second argument, so it counts numbers only, in the visible rows (filtered or manually hidden).
例如,在过滤和/或手动隐藏列表中的行之后,要仅计算可见数,请使用SUBTOTAL公式。 本示例使用102作为第二个参数,因此它仅对可见行(已过滤或手动隐藏)中的数字进行计数。
=SUBTOTAL(102,B2:B10)
=小计( 102 ,B2:B10)
In the screen shot below, there are 5 visible numbers in cells B2:B10, and that is the result in cell B15, where the SUBTOTAL function is used.
在下面的屏幕快照中,单元格B2:B10中有5个可见数字,这是单元格B15中使用SUBTOTAL函数的结果。
The COUNT function, used in cell B12 in the screen shot below, returns 8 – it counts numbers in the hidden rows too.
在下面的屏幕快照的单元格B12中使用的COUNT函数返回8 –它也对隐藏行中的数字进行计数。
观看幻灯片放映 (Watch the Slide Show)
To see a quick overview of 7 ways to count in Excel, you can watch this short slide show. It also contains a video on using the COUNTIFS function. You can see more examples on my Excel Count Functions page, and download the sample file.
要快速了解Excel中7种计数方式,您可以观看此简短的幻灯片演示。 它还包含有关使用COUNTIFS功能的视频。 您可以在“我的Excel计数功能”页上看到更多示例,并下载示例文件。
使用COUNTIF函数计算特定项目 (Count Specific Items With COUNTIF Function)
This video shows how to use the COUNTIF function to count cells that contain a specific string of text, such as "Pen".
该视频显示了如何使用COUNTIF函数对包含特定文本字符串(例如“笔”)的单元格进行计数。
翻译自: https://contexturesblog.com/archives/2015/03/26/how-to-count-in-excel/
excel中去重计数