+ Reply to Thread
Results 1 to 2 of 2

count the number of occurance based on time and date and specific criteria

  1. 10-02-2014, 01:25 PM #1
    stoey
    stoey is offline
    Forum Contributor
    Join Date
    08-07-2008
    Location
    United States
    MS-Off Ver
    Microsoft Office 2003
    Posts
    362

    count the number of occurance based on time and date and specific criteria

    hi,

    anyone knows how can I count the number of occurrence based on date and time frame together with specific data? I have attached a sample workbook. Please help.

    thanks in advance.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-02-2014, 03:34 PM #2
    Arkadi
    Arkadi is offline
    Forum Expert Arkadi's Avatar
    Join Date
    02-13-2014
    Location
    Smiths Falls, Ontario, Canada
    MS-Off Ver
    Office 365
    Posts
    5,059

    Re: count the number of occurance based on time and date and specific criteria

    Try this sheet... formulas put into the table for you.
    Attached Files Attached Files
    Please help by:

    Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
    Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know

    There are 10 kinds of people in this world... those who understand binary, and those who don't.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count number of cells with specific date and time range
    By cle12000 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-25-2013, 01:42 PM
  2. search for specific string in the sheet and count occurance of it
    By kmksprasad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-23-2012, 02:32 PM
  3. [SOLVED] Count the occurance of a number or text in a range that meets other criteria
    By kaneohe247 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2012, 12:51 PM
  4. count the number of occurance base on criteria
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-07-2009, 01:31 PM
  5. Using Date & Time Criteria to Count Entries in a Combined Date & Time List
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-28-2005, 10:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1