Sumifs in alteryx

[Amy123]

@ChrisTX @JoeHerbert 

If in excel you use this formula the Order bal will be Zero. 

Joe, I used the summarize tool and then the order Bal turn to 200,000 this is not correct as per logic.

Order Number	Accounting colour amount	Order Bal	SUMIFS($B$1:$B$1,$A$1:$A$1,A1)
5085980	200,000	0

[JoeHerbert]

@Amy123 Hi Amy, you can use a summarize tool, like so: 

Happy solving 

Joe 

[ChrisTX]

Can you re-phrase the question?

Is this an accurate description of the problem:

You have 14 rows of data. You want to calculate a sum of column B for only the first 10 rows of data, where the value in column A equals the value in cell A2?

Chris

[Amy123]

@ChrisTX 

If in excel you use this formula the Order bal will be Zero. 

I want the same in alteryx.

Order Number	Accounting colour amount	Order Bal	SUMIFS($B$1:$B$2,$A$1:$A$2,A1)
5085980	200,000	0

[JoeHerbert]

Hi @Amy123 , please make sure you have the summarize tool configured as per and the answer will be 0: 

[JoeHerbert]

@Amy123 please could you mark the solution as accepted and I can close this off? 

Thanks