Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Unique Items with Multiple Criteria
=SUMPRODUCT((1/COUNTIF(A2:A7,A2:A7&"")*(B2:B7<"")))
"Joe Gieder" wrote: First thank you for your help. I'm trying to count unique values based on criteria in another column. What I'm trying to do is count vendors when they have a value associated with them in another column. An example is: A2 TRIUMPH B2 2 A3 TRIUMPH B3 3 A4 TRIUMPH B4 3 A5 ABC B5 2 A6 ABC B6 5 A7 DEF B7 blank (nothing entered) result should be 2 because I don't want to count the blank cells. Is there any way this can be done? Thank you for your help Joe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Unique Items with Multiple Criteria | Excel Worksheet Functions | |||
Counting unique items...please help | Excel Worksheet Functions | |||
counting unique items(values or text) | Excel Worksheet Functions | |||
retrieve unique items with 2 criteria | Excel Worksheet Functions | |||
counting unique items | Excel Discussion (Misc queries) |