Sum Single Column based on Multiple Name Appearances Across Columns
Hopefully you can assist.. We have multiple people working on numerous packing efforts. Their name can appear in Column 1, 2 or 3. Column 1 is the lead and columns 2 and 3 assist. When one person completes the job they get full credit, 2 then .5 with 3 shared at .33.
I want to show a table with the packer names across the top and the dates (data column not shown) on the left. How do I sum a single column (Packs) when the names can appear in either column 1, 2 or 3?