Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Project Approved Type TypeSummary "HowManyProj"
-------- ----------- ----- ---------------- ---------------- Green 1/5/08 Charity Charity 3 Green 1/5/09 Profit Profit 2 Blue 1/7/09 Neutral Neutral 1 White 1/7/08 Profit Red Charity Blue 1/15/09 Charity Green Profit Yellow 1/16/08 Charity Green Charity Manual answer is "How Many Projects" How do I develop a formula that will tell me "How Many Unique Project Names" of the "Charity" type have an "Approval Date"(3, Green, Blue, Yellow) How many unique of the "Profit" type have an approval date (2, Green, White) And how many unique of the "Neutral" type have an approval date (1, blue) Quite a challenge. -- Jorge.R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complex conditional summing - array COUNT works, array SUM gives#VALUE | Excel Worksheet Functions | |||
Complex Function: Match names on Two Sheets | Excel Worksheet Functions | |||
Finding unique names--then converting those names to unique number | Excel Discussion (Misc queries) | |||
Array Formulas - Unique List from List with Duplicates | Excel Discussion (Misc queries) | |||
Help with complex index array issue | Excel Worksheet Functions |