Results 1 to 7 of 7

Excel 2007 : Counting with Criteria Problem.

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    4

    Counting with Criteria Problem.

    Greetings,

    I have what I believe is quite a challenging problem to solve.
    I have a list of times in one column, and a list of aircraft types in another column.

    What I need is a way to search an array of times, and return a number of how many of each aircraft type is listed in that time array.

    Example: how many 763 aircraft are listed between 14:00 and 14:59

    I've attached a worksheet of data as an example of the data I'm dealing with. I hope someone can help with this. The actual data set will be significantly larger, but this should do for an example.

    Thanks in advance.
    Chris
    Attached Files Attached Files
    Last edited by Kinf00; 07-28-2011 at 04:50 PM.

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