Thread: Count Unique Values from a Subset of a List
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HKaplan HKaplan is offline
external usenet poster
  
Posts: 80
Default Count Unique Values from a Subset of a List
Like using sumif?

=SUMIF(A1:A8,"dog",B1:B8). The answer would be 7 using your numbers
above.

If dog and cat entries are in Column A and the numbers are in Column
B, this formula would give you the total in B for every entry of dog
in A.

Does that give you what you want?
Reply With QuoteReply With Quote