计算列A中具有工作表2中B列中的列的值的行数 [英] Count number of rows in column A that have a value in a list in column B on worksheet 2

问题描述

我在列A表2中列出了EST时区中的3位电话代码。

我想要做的是在Sheet 1B2中计算EST时区列表（列A Sheet 2）中存在的入站呼叫数（列A Sheet 1）。

我似乎无法找到一种使用公式或宏来完成此操作的方法。

解决方案

p>你会想要这样的：

  = COUNTIF（A：A，'Sheet2'！A ##）
  

只需将 A ## 替换为3的位置您要计算的表格2的数字代码。

编辑：
这是解决您的问题的代码。它计算Sheet2！A：A中的任何值在Sheet1中迭代的次数！A：A

  = SUM（COUNTIF （Sheet1！A：A，Sheet2！A：A））
  

I have a list of 3 digit phone codes in EST timezone in column A Sheet 2. I have in Column A Sheet 1 another list of 3 digit phone codes from people that have called in.

What I am trying to do is in Sheet 1 "B2" count the number of inbound calls (Column A Sheet 1) that exist in the EST timezone list (Column A Sheet 2).

I cannot seem to find a way to complete this using either formulas or macros.

解决方案

You'll want something like this:

=COUNTIF(A:A,'Sheet2'!A##)

Just replace A## with the location of the 3 digit code from sheet 2 that you want to count.

EDIT: Here is the code which solves your question. It counts the number of times any value within Sheet2!A:A is iterated in Sheet1!A:A

=SUM(COUNTIF(Sheet1!A:A,Sheet2!A:A))

这篇关于计算列A中具有工作表2中B列中的列的值的行数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！