19603

Count number of rows in column A that have a value in a list in column B on worksheet 2

Question:

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.

Answer1:

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))

Recommend

  • Content based file moving with Mule
  • What is the proper Java Config for simple file copy
  • BPEL Designer for Eclipse: how to debug a BPEL process
  • ColdFusion with IIS URL Rewrite - Page never finishes loading
  • working with Nested IF statement in excel
  • Omit template arguments when create an instance of template class from another instance of template
  • Check if one value in one column is in another column
  • No error while instantiating abstract class, even though abstract method is not implemented
  • Retrieving a contacts notes
  • Installing apk from within application in android
  • How to merge two Request in Laravel
  • Unique SMS sender id?
  • Updating both a ConcurrentHashMap and an AtomicInteger safely
  • Using Sax parsing to edit and write XML in VB6
  • Groovy: Unexpected token “:”
  • Installing iPhone App to iPhone
  • Xcode 4 NSLog Macro link in Xcode 3
  • Abort upload large uploads after reading headers
  • Replace value with Factor in r data.table
  • Unity3D & Android: Difference between “UnityMain” and “main” threads?
  • Django: Count of Group Elements
  • How to access EntityManager inside Entity class in EJB3
  • Repeat a vertical line on every page in Report Builder / SSRS
  • Is there a javascript serializer for JSON.Net?
  • Does CUDA 5 support STL or THRUST inside the device code?
  • Sending data from AppleScript to FileMaker records
  • MySQL WHERE-condition in procedure ignored
  • Where to put my custom functions in Wordpress?
  • Why winpcap requires both .lib and .dll to run?
  • Data Validation Drop Down Box Arrow Disappearing
  • PHP: When would you need the self:: keyword?
  • Buffer size for converting unsigned long to string
  • How to set the response of a form post action to a iframe source?
  • Can Visual Studio XAML designer handle font family names with spaces as a resource?
  • File not found error Google Drive API
  • Qt: Run a script BEFORE make
  • How to get Windows thread pool to call class member function?
  • Are Kotlin's Float, Int etc optimised to built-in types in the JVM? [duplicate]
  • unknown Exception android
  • Binding checkboxes to object values in AngularJs