+ Reply to Thread
Results 1 to 2 of 2

using countifs to track unique values over a date range

  1. #1
    Registered User
    Join Date
    02-10-2014
    Location
    Washington, DC
    MS-Off Ver
    Excel 2010
    Posts
    1

    using countifs to track unique values over a date range

    Hello!

    I am trying to track users and the number of times they use a product over a (-90/90) time frame of a date the product is presented to them. Basically tracking the effectiveness of the presentation. I have already tracked product usage, but want to track when unique users adopt this product as well. I have a great start on the spreadsheet attached, but need this one last formula.
    Help????
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-08-2013
    Location
    Boston, USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: using countifs to track unique values over a date range

    Did you get the answer? Otherwise I can suggest solving this using R, but not excel.

+ 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. COUNTIFS with Unique Values
    By lefteegunzz in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2013, 04:25 PM
  2. Using countifs with date range, and summing values in that range
    By bmcoonan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2013, 11:28 AM
  3. Countifs with unique values & dates
    By lanos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2012, 09:11 AM
  4. Replies: 2
    Last Post: 06-04-2012, 12:22 PM
  5. Excel 2007 : Using countifs to count unique values
    By AlexZoom in forum Excel General
    Replies: 2
    Last Post: 09-23-2010, 09:41 AM

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