i have table contain three columns( Tank no. , Depth , Quantity )
i need formula to extract the quantity of any selected tank based on actual tank's depth
For example
Tank no. 6 , depth 1 meter ,Quantity =8073
i have table contain three columns( Tank no. , Depth , Quantity )
i need formula to extract the quantity of any selected tank based on actual tank's depth
For example
Tank no. 6 , depth 1 meter ,Quantity =8073
Try in J2
=SUMIFS(C:C,A:A,H2,B:B,I2)
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
Ace_XL YOU ARE THE MAN
THATS WORK PERFECTLY
MANY THANKS FOR YOUR HELP
Moreover.. How to change cell value J2 based on tank number in cell H2 ?
Thanks in advance
Perhaps I don't understand what you are asking.
Using Ace_XL's formula the value in J2 does change when the tank number in H2 changes.
Please clarify what it is that you want by giving a specific example that references the file attached to post #1 or post a new file that illustrates what you are asking.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks