Count Look up field

Summary: When two lists are connected via a look up column, you can create another look up column in the primary list to count how many times that item is referenced in the secondary list.

Instructions:

1. Create 2 lists.
2. Create a look up column in the secondary list that looks up data in the primary list
3. Create another look up column in the primary list, select the secondary list in the dropdown menu
4. Instead of displaying a field, you will see count.
5. This count will give you the total number of items that the each primary list item is reference in the secondary list.