Greetings
I need help with a formula for adding up amounts
Sheet 1 date for LOT1 ,LOT 2 & LOT 3 will look at the date in Sheet 2 and from Sheet 3 look at which letter belongs to which LOT...It will then total up the amount for each LOT according to date...eg attached..
Bookmarks