To fill in the ??? in attached file, I select the respective cells and SUM.
Would there be a way to automate as :
For each entry in column D, Excel picks out itself the names in column-A where-ever they come, picks the corresponding values from column-B, sums them and reproduces the summation in column E.
Thanks.
Bookmarks