complex problems count based on many levels of criteria
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).
Last edited by joannelittell; 10-28-2013 at 04:55 PM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By dtrimble in forum Excel General
Last Post: 08-23-2011, 08:47 PM
By Deks in forum Excel General
Last Post: 10-30-2010, 05:32 AM
By Alash in forum Excel General
Last Post: 05-05-2010, 10:32 AM
By JapanDave in forum Excel General
Last Post: 05-25-2009, 04:36 AM
By Rob in forum Excel Formulas & Functions
Last Post: 05-04-2005, 10:06 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1