Excel Forum



Excel Magic Trick 726: Count 1 For Each Item in List 1 That Is In List 2 No Double Count for Dups


Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to use the SIGN, COUNTIF and SUMPRODUCT functions to Count 1 For Each Item in List 1 That Is In List 2 -- No Double Count for Duplicates. There are multiple criteria for counting, but we need a 1 even when there are duplicates in List.





Got a Question? Ask it Here in the Forum.