Forum Discussion

thorntonasami's avatar
thorntonasami
Copper Contributor
Jul 31, 2018

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 to know how much left by sizes in total. (Each size with "ship-out date" column blank)

I can easily do that if it's only a page but I have many tabs.

Could you please advise which function can I use if any??

Thank you in advance.

excel
Formulas and Functions
  • pranav trikha's avatar
    pranav trikha
    Brass Contributor
    Aug 03, 2018

    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, 

Resources