+ Reply to Thread
Results 1 to 2 of 2

Counting Tracks Played Over a Period

  1. #1
    Registered User
    Join Date
    02-04-2011
    Location
    North East
    MS-Off Ver
    2013
    Posts
    11

    Counting Tracks Played Over a Period

    Hi All

    I'll get straight to the point. I have a playlist of tracks that have been played from a playlist over the period of a month, I have the list in excel format and need to use the countif formula to show me the following.

    Show me how many times each unique track has been played in that month.

    I believe the countif formula is the right one to use but can't work out how to do it. It may be that I have to create a second column to list all the unique tracks from the first column then create a third column showing how many times each has been played, or is this complicating things?

    I hope this makes sense, if not let me know and I will try and explain a little better.

    Thanks in advance

    Nelix

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: CountIF

    I would recommend highlighting the data, then applying a Pivot Table. If you put the Track Names in the rows, and the dates played in the columns, then you should get a count by default.

    If you're not familiar with Pivot Tables, you're in for treat. No need to manually consolidate any data summary, the Pivot Table does it for you, just need to get in there and get your feet wet.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

+ 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. Time period specific counting
    By lunarstablos in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-02-2013, 10:54 AM
  2. Counting days stayed during certain time period
    By analystEK in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2013, 05:00 PM
  3. Counting dates within a period of time
    By Justinmih in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-06-2008, 07:15 PM
  4. Counting dates within a period of time
    By rjchudek in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-04-2007, 05:09 PM
  5. [SOLVED] I need to create a job task list that tracks for a 30 day period.
    By Job Task tracker in forum Excel General
    Replies: 1
    Last Post: 12-30-2005, 10:10 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