Excel Forum
Similar Content
Input Form to Get Data and Store it in Another Tab in Excel
Tutorial: How to make a user input form in Excel and have the data stored on another worksheet at th...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel.  This includes Ex...
Get User Submitted Data from a Prompt in Excel using VBA Macros
Tutorial: How to prompt a user for their input in Excel. There is a simple way to do this using VBA ...



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.