Results 1 to 4 of 4

Count different entries for time intervals

Threaded View

  1. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2504
    Posts
    13,745

    Re: Count different entries for time intervals

    I am not sure I have the concept(s). Please check the attached.

    For the column I comparisons I have copied column A, pasted into column P and removed duplicates. The <358,9 and >298,9 criteria are in Q1:R1. Then this formula in Q2 filled down and across. There are numbers > 0 returned in column Q but not in column R.
    Formula: copy to clipboard
    =COUNTIFS($A:$A,P2,$I:$I,Q$1)


    In columns T:V the setup is the same. Attempted to do comparisons for G:H respectively. I suspect this one is wrong, but please have a look and give me guidance. In U2 filled down and across.
    Formula: copy to clipboard
    =COUNTIFS($A:$A,T2,G:G,U$1)
    Dave

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 6
    Last Post: 11-26-2014, 10:35 PM
  2. IF statement for count of entries outside of specified time
    By jdstuffel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-03-2014, 11:15 AM
  3. Excel 2000 Count Entries within a time frame.
    By Daniel Salinas in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-10-2014, 12:10 PM
  4. Count of current chats (time intervals)
    By Alex Fate in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-09-2013, 02:22 AM
  5. Converting Data in Irregular Time Intervals into Regular Time Intervals
    By AlexJT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 02:42 AM
  6. Need to Transpose Irregular Time Intervals into Regular Time Intervals
    By AlexJT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2011, 08:30 PM
  7. Count time (entries per hour)
    By canonelan2 in forum Excel General
    Replies: 6
    Last Post: 10-07-2008, 03:23 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