Sum by criteria

[nihou]

I am trying to sum by agreement then contract, but if that agreement and contract number have A Code =10, then I want it to sum them together? I have source and desired outcome below:

Source		Outcome
C Number	A Number	Code	Date	A Code	Vol	Vol2		C Number	A Number	Code	Date	A Code	Vol	Vol2
129A	72	03	08/31/2017		10	11		129A	72	03	08/31/2017	10	100	1
129A	72	03	08/31/2017	10	90	-10		129A	72	04	08/31/2017	10	60	1
129A	72	04	08/31/2017	10	60	1		129A	72	07	08/31/2017	10	-6	0
129A	72	07	08/31/2017		33	0		129A	72	15	08/31/2017	10	24	3
129A	72	07	08/31/2017	10	-39	0		160	72	03	08/31/2017	10	105	0
129A	72	15	08/31/2017		6	1		160	72	04	08/31/2017	10	64	8
129A	72	15	08/31/2017	10	18	2		160	72	07	08/31/2017	10	-7	0
160	72	03	08/31/2017		10	1		160	72	15	08/31/2017	10	78	10
160	72	03	08/31/2017	10	95	-1		129A	13	39	08/31/2017		45	5
160	72	04	08/31/2017	10	64	8		160	13	39	08/31/2017		45	5
160	72	07	08/31/2017		33	0		129A		03	08/31/2017		49	5
160	72	07	08/31/2017	10	-40	0		129A		07	08/31/2017		15	0
160	72	15	08/31/2017		60	8							572	38
160	72	15	08/31/2017	10	18	2
129A	13	39	08/31/2017		45	5
160	13	39	08/31/2017		45	5
129A		03	08/31/2017		49	5
129A		07	08/31/2017		15	0
					572	38

[AngelosPachis · Accepted solution]

Hi @nihou .

Not sure I understand the requirements fully, but this workflows seems to be giving the output that you are after?

[nihou]

@AngelosPachis thank you! This worked! First time using "First"!