I have such data in left table and i want to insert it into right table using sumif formula. but I don't know how to limit the sumif range from one branch to another branch. and the data product in each branch is dynamic based on the products sold.
does anyone have suggestion? any answer will be greatly appreciated. thank you
