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 |
All times are GMT +1. The time now is 04:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com