Hello, I'd like to figure out a formula that will consolidate values of lines belonging to the
same family in table 1(see attached excel sheet) and pull that sum into the respective line in table 2. I will constantly be
adding new names to table 1, inserting rows, etc. so do not want this to throw off the
formula. Can you please advise on a good way to do this? I have a complele list of
Family Names (like those in table 2) which will not change, as well as a complete list
of Account names (Table 1) that also will not change. These sheets are also located in
different workbooks.
Thanks!
Vijay
Bookmarks