Need a formula for advance filter criteria

[Enki03]

So I'm in charge of handing Fifo in our inventory and I need a formula to speed the process since the material handlers work quick through the day. Our system is simple we have a database that spills out reports with all kind of information. Such as serial, part number, quantity and so on. I use power query to clean up the report and advance filter to display the part numbers that the material handlers need to pick. But I need to display the actual quantities they need and that's what's consuming my time because I have to go by part number by part number adding quantities manually. They are given a pick list and I need to supply with serials and locations based on FIFO, been researching but I haven't found anything yet. Anybody knows how to accomplish this? Anything will help thanks!

Example spreadsheet:

Filebin | k1t90m3q6papl3yu

Convenient file sharing. Think of it as Pastebin for files. Registration is not required. Large files are supported.

filebin.net

 

[maabadi]

1. You can Use sumif or Sumifs formula
2. You can Use Pivot Tables

Redditexcel.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z
1	serial_id	Part_id	Qty	location_id	createdate
2	11156	10007876	10	R305	8/5/2020
3	11257	10007876	20	R305	8/5/2020						Row Labels	Sum of Qty
4	11457	10007876	20	R305	8/6/2020						10004788	181
5	16547	10007876	41	D507	8/7/2020						10004897	60
6	13554	10007876	26	D507	8/8/2020						10005688	24
7	25665	10005689	25	A308	8/9/2020						10005689	25
8	12542	10004897	30	S405	8/10/2020						10007874	18
9	16654	10004897	30	S405	8/11/2020						10007876	117
10	25558	10005688	24	F608	8/12/2020		PICKLIST FOR MATERIAL HANDLER				10008125	96
11	25555	10007874	8	H307	8/13/2020						10009712	64
12	36594	10007874	10	H307	8/14/2020		Part_id	Qty			Grand Total	585
13	15542	10008125	15	G205	8/15/2020		10007876	60	117
14	25515	10008125	15	G205	8/16/2020		10008125	35	96
15	26544	10008125	15	G205	8/17/2020		10004788	135	181
16	15555	10008125	25	T503	8/18/2020		10004897		60
17	15655	10008125	26	T503	8/19/2020		10005688		24
18	15545	10009712	49	Y407	8/20/2020		10005689		25
19	55255	10009712	15	Y407	8/21/2020		10007874		18
20	26655	10004788	12	E309	8/22/2020		10007876		117
21	23655	10004788	19	E309	8/23/2020		10008125		96
22	12652	10004788	26	E309	8/24/2020		10009712		64
23	13652	10004788	48	J205	8/25/2020
24	15594	10004788	29	J205	8/26/2020
25	12563	10004788	47	J205	8/27/2020
26
27	How can I filter by those part numbers and add up to or get close to those quantities?
Database

Cell Formulas
Range	Formula
I13:I22	I13	=SUMIFS($C$2:$C$25,$B$2:$B$25,G13)