+ Reply to Thread
Results 1 to 3 of 3

Count number of instances

  1. #1
    Registered User
    Join Date
    06-20-2007
    Posts
    9

    Count number of instances

    I have on a sheet a list of phone calls made from various extentions. Example below

    Calling Party Dialed Number
    2255 6700
    2255 6700
    2007 6700
    2255 3456
    2007 6321

    I want to count the number of times each extention dials 6700. So the results from the above data would look something like this:

    2255 = 2
    2007 = 1

    I've been playing around with COUNTIF but not getting anywhere. Can anyone suggest a function that may do the trick?

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,111
    G'day

    Try this

    Please Login or Register  to view this content.
    Please adjust you ranges to suit data and you can use cell references instead of typing in the criteria your looking for

    HTH
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Registered User
    Join Date
    06-20-2007
    Posts
    9
    Excellent thank you that worked a treat!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Count the number of highlighted cells
    By Ford_Guy in forum Excel General
    Replies: 13
    Last Post: 07-17-2008, 08:17 AM
  2. Count Number of Lines in a .txt file
    By macro_noob in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-14-2008, 12:01 AM
  3. Count number of several actions which are done
    By amannan in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-19-2008, 11:39 PM
  4. Count number of cells with different entries
    By ebneterc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2007, 06:10 AM
  5. count the row from my vlookup number to zero
    By qwervbnmasdf in forum Excel General
    Replies: 6
    Last Post: 01-30-2007, 02:09 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1