formula help

[jeff]

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..

https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA

[aju.thomas]

Hope this will help you.

in sheet 2, Copy below formula to column g7 to g28

=IF(ISNA(MATCH(E7,Sheet3!$F$6:$F$14,0)),IF(ISNA(MA TCH(E7,Sheet3!$G$6:$G$14,0)),IF(ISNA(MATCH(E7,Shee t3!$H$6:$H$14,0)),"","Lot 3"),"Lot 2"),"Lot 1")

in sheet 1, copy below formula to column g8 to o10

=SUMIFS(Sheet2!$F$7:$F$28,Sheet2!$D$7:$D$28,Sheet1 !G$7,Sheet2!$G$7:$G$28,Sheet1!$F8)

[Admin]

Hi

In G8:

=SUMPRODUCT(SUMIFS(Sheet2!$F$7:$F$28,Sheet2!$E$7:$ E$28,Sheet3!$F$7:$F$14,Sheet2!$D$7:$D$28,G$7))

Replace the highlighted range accordingly for Lot 2 and Lot 3.