Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'd like to apply some additional criteria to this unique value count.
=SUM(IF(FREQUENCY(IF(C:C=A5,D:D),D:D),1)) The array formula works ok without additional criteria. However, I'd also like to include the rows where cells in E:E equal 5 and F:F equal 4. I've done a SUMPRODUCT that would determine that without determining the unique values, but I want to somehow combine the two. Any ideas. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate FREQUENCY based on criteria... | Excel Discussion (Misc queries) | |||
counting frequency using multiple ranges/criteria | Excel Worksheet Functions | |||
Frequency of data with criteria | Excel Worksheet Functions | |||
frequency formula with criteria | Excel Worksheet Functions | |||
Frequency of values with Criteria | Excel Worksheet Functions |