Results 1 to 8 of 8

Count unique days within month

Threaded View

  1. #1
    Registered User
    Join Date
    08-10-2010
    Location
    Prague
    MS-Off Ver
    Excel:Mac 2011
    Posts
    13

    Count unique days within month

    hi,

    i need for my analyses number of unique days within a month:

    column B - dates (some days are missing, some days have 20 lines, some have 1 line)
    column C - =Month(Bx)

    I need to count number of days within given month.

    to count all unique days, i use this:
    =SUM(IF(FREQUENCY(INPUT!B15:B2000;INPUT!B15:B2000)>0;1))

    how do I add the condition IF Cx=8 ?

    thanks,
    Jirka
    Last edited by jirib; 08-26-2010 at 06:44 AM. Reason: Solved

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