+ Reply to Thread
Results 1 to 1 of 1

complex problems count based on many levels of criteria

  1. #1
    Registered User
    Join Date
    04-23-2013
    Location
    normal, il
    MS-Off Ver
    Excel 2010
    Posts
    66

    complex problems count based on many levels of criteria

    Hello!

    I need some help with a complex formula. I have thousands of rows of data that is continuously increasing.

    There are two ways the data can be looked at (across Type only and across Type and Size combo).

    I need to find the number of times for each a month/year and CP type in which there was a problem. Specifically, if a Type fails (once or more) on any of the series (1-6), then it needs to be counted ONLY ONCE.

    In addition, for both these ways, the data needs to be parsed by month/year and CP type.

    For Type Only
    If everything is ok for that Type, then it is a "0" for that Type
    If one or more problems are identified within a Type, then it needs to be counted only ONCE (no matter how many problems were identified)

    For Type and Size combination
    If everything is ok for that type and size combo, then it is counted as a "0"
    If one or more problems are identified within a Type and Size combo, then it needs to be counted only ONCE (no matter how many problems were identified)

    I am fine with adding columns to help with the formulas.

    I included mock data along with what that data should look like. Its pretty complicated, so I colored the data to help identify the Type (color) and Type and Size (light/dark).
    Attached Files Attached Files
    Last edited by joannelittell; 10-28-2013 at 04:55 PM.

+ 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. Count based on complex logic
    By dtrimble in forum Excel General
    Replies: 7
    Last Post: 08-23-2011, 08:47 PM
  2. Selecting Numbers based on Complex Criteria
    By Deks in forum Excel General
    Replies: 12
    Last Post: 10-30-2010, 05:32 AM
  3. Replies: 5
    Last Post: 05-05-2010, 10:32 AM
  4. Complex multi criteria lookup and count formula???
    By JapanDave in forum Excel General
    Replies: 9
    Last Post: 05-25-2009, 04:36 AM
  5. [SOLVED] Count using complex criteria
    By Rob in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2005, 10:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1