View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default 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