+ Reply to Thread
Results 1 to 4 of 4

counting days operated without repeating

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    KSA
    MS-Off Ver
    2011 MAC & Mac 2015
    Posts
    54

    Question counting days operated without repeating

    hello everyone

    so I'm frustrated as I'm trying to find the right way of counting days an aircraft flown each month

    please find attached excel sheet.

    in sheet 2 , I'm trying to calculate in C2 the number of days that the aircraft flown based on dates in sheet1 C:C without repeating counting dates. I've seen couple of complicated formula :

    =SUMPRODUCT((Sheet1!C:C<>"")/COUNTIFS(Sheet1!C:C,Sheet1!C:C&""))
    calculating came 119 in sheet2 cell H2 which is this is the right total but for all the dates in C2. it didn't filtered based on each month

    i tried the following formula
    =COUNTIFS(Sheet1!C:C,Sheet1!B:B=B2)
    calculating came 0 . in Sheet2 cell I2


    Sheet 2 been built in Basic way which i had to enter all data manually .
    (A column represent the number of days of each month in 2015 ) and i entered these manually because i wanted to get in E column the number of days that my aircraft didn't fly .
    F Column also represent in percentage the datess of aircraft flown ( C2/A2)


    your help is really appreciataed
    regards,
    hani


    p.s / I'm using Mac operating system and the file is save as .xlsx
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: counting days operated without repeating

    with a pivot table to count the unique value.

    see the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    02-27-2013
    Location
    KSA
    MS-Off Ver
    2011 MAC & Mac 2015
    Posts
    54

    Re: counting days operated without repeating

    thank you

    but i couldn't understand how did you calculated the count unique value in the pivot table as when i tried to open it its says content been disconnected ( i can't track the data you customized)

    I'm using excel 2015 mac Version 15.13.3

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: counting days operated without repeating

    Maybe the unique count in the pivot table is not available in the mac version.

    But I don't know that, since I don't use the mac version.

+ 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. [SOLVED] How to find Sum of # of days w/o counting overlapping days twice
    By lanksout in forum Excel General
    Replies: 18
    Last Post: 08-11-2015, 02:15 AM
  2. Repeating Days
    By teoxu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2015, 12:51 PM
  3. Macro after Spin Button operated
    By Southernw2002 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-08-2014, 12:59 AM
  4. Macro operated by the table or list
    By Nem0 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2014, 12:37 AM
  5. [SOLVED] Count number of days from column of repeating dates
    By Edwardbigfoot in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-28-2013, 04:22 PM
  6. Replies: 2
    Last Post: 10-14-2012, 09:19 AM
  7. Replies: 9
    Last Post: 09-03-2007, 08:26 PM

Tags for this Thread

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