Results 1 to 3 of 3

Counting Unique Entries (Dates, specifically)

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2010
    Location
    Upland, California
    MS-Off Ver
    Excel 2007
    Posts
    5

    Counting Unique Entries (Dates, specifically)

    Hello,
    I'm looking to count the number of unique dates in a given range, using an equation that combines the two below:

    =SUM(IF(FREQUENCY(D3:D15,D3:D15)>0,1))

    This equation gives me the count of unique entries (dates) in the range of selected cells.

    Since this is a huge spreadsheet that would be very time consuming to set a range for every single entry, I'm trying replace the existing range in red with a technique similar to this sum equation:

    =SUMIFS(G:G,F:F,F3)

    where the sum of another set of data is filtered by the criteria in an adjacent cell in row F.

    I would appreciate any help.

    Thanks
    Stephen
    Attached Files Attached Files
    Last edited by rylo; 10-07-2010 at 01:06 AM.

Thread Information

Users Browsing this Thread

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

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