excel单元格文本应用_在Excel中计算具有特定文本的单元格

excel单元格文本应用

While working on a client's sales plan last week, I had to count the orders for a couple of specific customers. This tutorial shows how to count cells with specific text in Excel.

上周在制定客户的销售计划时，我不得不计算几个特定客户的订单。 本教程介绍了如何在Excel中对具有特定文本的单元格进行计数。

客户数据样本 (Customer Data Sample)

Here's a screenshot of some sample data, with the customer names in column B.

这是一些示例数据的屏幕截图，客户名称在B列中。

计算完全匹配的单元格 (Count cells that are an exact match)

In Excel, you can use the COUNTIF function to count cells that meet a specific criterion. For example, you can use this formula to count the orders that were placed by the customer, BigMart.

在Excel中，您可以使用COUNTIF函数对满足特定条件的单元格进行计数。 例如，您可以使用此公式来计算客户BigMart下的订单。

=COUNTIF($B$2:$B$14,"BigMart")

= COUNTIF($ B $ 2