Forum Discussion
Sums of data between tabs
Hello all, I have an excel file and the file has lots of sheets. Each sheets contains following information of a product. (sizes, weights, ship out date and so on) What I need to do is I want...
Greetings!
As understood, have put in data in separate tabs, Col A (Products), Col B,C,D in Sheet 2 are the criteria's,Sheet 3 consists of data of Qty of Items ordered. If Criteria's not available for product in Sheet 3, they can't be ordered, condition has been considered in Sheet 1 (which sums total of products ordered).
Kindly find attached, hope it helps!
Thanks,