Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
90
Views
Topic starter
Good day, I have a work book with 2 tabs, I am required to find out the lifting for "JBB" for the year 2018 for each individual origin and destination. Could anyone teach me the right way to find it? Hope attached helps.
Posted : 07/08/2019 2:04 am
Hi ST,
Welcome to our forum. You can use an INDEX and MATCH array formula or SUMIFS. See columns E and F of sheet YKK 2019 award in the file attached.
Mynda
Posted : 07/08/2019 5:55 am
