SUM of Items within the same Order.

[roenajoyave]

I have been racking my brain to figure this out. I need to sum up the cost of 2 items but they need to be in the same order. These items can be on their own, but I don't want to sum those. They have to be within the same order number.

My data rows are per item in the order.

Order Number	Invoice Line Number	Invoice Date	Item Number	Ordered Quantity	Unit List Price	Order Line Total
130513193​	1​	01-Nov-2022​	1033574	1.00​	75.44​	75.44​
130513193​	2​	01-Nov-2022​	1035417	1.00​	10.06​	10.06​
130513194​	1​	01-Nov-2022​	1035417	1.00​	10.06​	10.06​
130513194​	2​	01-Nov-2022​	1004883	1.00​	60.35​	60.35​
130513196​	1​	01-Nov-2022​	1033574	1.00​	75.44​	75.44​
130513196​	2​	01-Nov-2022​	1035417	1.00​	10.06​	10.06​
130513197​	1​	01-Nov-2022​	1035417	1.00​	10.06​	10.06​
130513197​	2​	01-Nov-2022​	1004883	1.00​	60.35​	60.35​
130513198​	1​	01-Nov-2022​	1012787	1.00​	148.73​	148.73​
130513199​	1​	01-Nov-2022​	1161020	1.00​	313.80​	313.80​
130513200​	1​	01-Nov-2022​	1014326	1.00​	39.12​	39.12​
130513200​	2​	01-Nov-2022​	1017991	1.00​	60.86​	60.86​
130513200​	3​	01-Nov-2022​	1005510	1.00​	39.12​	39.12​
130513201​	1​	01-Nov-2022​	1161020	1.00​	313.80​	313.80​
130513202​	1​	01-Nov-2022​	1012787	1.00​	148.73​	148.73​
130513203​	1​	01-Nov-2022​	1161020	1.00​	313.80​	313.80​
130513204​	1​	01-Nov-2022​	1014326	1.00​	39.12​	39.12​
130513204​	2​	01-Nov-2022​	1017991	1.00​	60.86​	60.86​
130513204​	3​	01-Nov-2022​	1005510	1.00​	39.12​	39.12​
130513205​	1​	01-Nov-2022​	1033574	1.00​	75.44​	75.44​
130513205​	2​	01-Nov-2022​	1035417	1.00​	10.06​	10.06​

 

[Asbestos_Jen]

I'm not sure where you want your output or what it would look like, but something like this would work.

2023-12-20.xlsx
	B	C	D	E	F	G	H	I	J	K
2	Order Number	Invoice Line Number	Invoice Date	Item Number	Ordered Quantity	Unit List Price	Order Line Total		Item	1035417
3	130513193	1	01-Nov-2022	1033574	1	75.44	75.44		Order	130513194
4	130513193	2	01-Nov-2022	1035417	1	10.06	10.06		Sum	1
5	130513194	1	01-Nov-2022	1035417	1	10.06	10.06
6	130513194	2	01-Nov-2022	1004883	1	60.35	60.35
7	130513196	1	01-Nov-2022	1033574	1	75.44	75.44
8	130513196	2	01-Nov-2022	1035417	1	10.06	10.06
9	130513197	1	01-Nov-2022	1035417	1	10.06	10.06
10	130513197	2	01-Nov-2022	1004883	1	60.35	60.35
11	130513198	1	01-Nov-2022	1012787	1	148.73	148.73
12	130513199	1	01-Nov-2022	1161020	1	313.80	313.80
13	130513200	1	01-Nov-2022	1014326	1	39.12	39.12
14	130513200	2	01-Nov-2022	1017991	1	60.86	60.86
15	130513200	3	01-Nov-2022	1005510	1	39.12	39.12
16	130513201	1	01-Nov-2022	1161020	1	313.80	313.80
17	130513202	1	01-Nov-2022	1012787	1	148.73	148.73
18	130513203	1	01-Nov-2022	1161020	1	313.80	313.80
19	130513204	1	01-Nov-2022	1014326	1	39.12	39.12
20	130513204	2	01-Nov-2022	1017991	1	60.86	60.86
21	130513204	3	01-Nov-2022	1005510	1	39.12	39.12
22	130513205	1	01-Nov-2022	1033574	1	75.44	75.44
23	130513205	2	01-Nov-2022	1035417	1	10.06	10.06
SumifsOrder

Cell Formulas
Range	Formula
K4	K4	=SUMIFS($F$3:$F$23,$B$3:$B$23,$K$3,$E$3:$E$23,$K$2)

Cells with Data Validation
Cell	Allow	Criteria
K2	List	=Items
K3	List	=Orders

 

[roenajoyave]

Sorry about the lack of description on where I would like it. I am trying to create either a calculated column or a measure that will do this in a Power Pivot.