Access data with 3 conditional

[phamanh1998]

Hello Everyone. I have a proble with access data.
I have to track the import-export of semi-finished products at all stages of each production order corresponding to each type of product.
I wish to access by product type name by the time period to return the final value corresponding to the purchase order and corresponding stage.

* Result 1: When I am searching by product type, it will return the last result of the inventory number of the Purchase order finally with Corresponding state.
For example: BN001 product type has three production orders 3616090/3616091/3616093, it will return the Purchase order finally result of balance at the last paragraph of order 3616093.

* Result 2: When searching by Product Type, the results of the last total inventory of the stages corresponding to the production orders of that product type
Example: Product type BN001 has three Corresponding state 3616090/3616091/3616093, then the final balance result will be returned at all stages of all production orders of product line BN001 as at the Mix stage. will be the total final balance at the mixing step of the three purchase orders

Thank you so much.

[Glenn Kennedy]

First Part:

=SUMIFS(G:G,D:D,$L$1,C:C,$L$2,B:B,$K4)

Second part:

=SUMIFS(G:G,D:D,$L$7,A:A,">="&L$8,A:A,"<="&$L$9,B:B,$K12)

in the second part, your expected answers for A & B were incorrect.

[phamanh1998]

Thank you for support.

In Result 1,I want value in L2; K4; K5 will auto when I choose value in L1.

In Result 2, I dont want sum total, I want to sum last value.

Hope you reply soon. Thank kiu

[JeteMc]

Hello phamanh1998 and Welcome to Excel Forum.
Try the following in cell L2:

Please Login or Register  to view this content.

Glenn's formula for L4:L5 works for the sample data, however I can see that if the data ended at row 5 there would be a problem so I offer the following alternative:
Try the following in cell L4 and then drag the fill handle down to cell L5:

Please Login or Register  to view this content.

I don't understand what "In Result 2, I dont want sum total, I want to sum last value" means.
Perhaps if you could tell us the cells summed to yield 63 in cell L12 then we will better understand.
Let us know if you have any questions.

[phamanh1998]

Thank for answer. In Result 2, I dont want sum total, I want to sum last value" that means I want to get the last value of Corresponding Stage to Purchase order of Product type.
Sample: BN001 i want sum the last value of A to Corresponding Stage 3616090,3616091, 3616093 respectively G4;G6;G13 ( sum L12=50 not 63).
Hope you reply soon. Thank kiu

[kvsrinivasamurthy]

One helper column H created.
In H2 then copy down

=IF(MAX(COUNTIFS($D$2:$D$18,$D2,$C$2:$C$18,$C2,$B$2:$B$18,$B2))=COUNTIFS($D$2:$D2,$D2,$C$2:$C2,$C2,$B$2:$B2,$B2),1,"")

In M12 then copy down

=SUMIFS($G$2:$G$18,$D$2:$D$18,$M$7,$B$2:$B$18,$L12,$H$2:$H$18,1)

[phamanh1998]

Thank you so much.