Sumifs function

[Amy123]

Hi,

Can anyone help how to write this on alteryx

=SUMIFS($B$1:$B$2,$A$1:$A$2,B3,$C$1:$C$2,"<>-")

Test data

Order Number	Accounting colour amount	Booking flag
2561895	-218,599	Closed
2561895	218,599	Closed
2571480	-7,627,360	Closed
2571480	0	Closed
2571480	7,627,360	Closed
2571480	0	Closed
2583986	-152,859	Closed
2583986	0	Closed
2583986	-13,500	Closed

[Pang_Hee_Choy]

Solved: SUMIF Function - Alteryx Community

add a join tool later.

[Sebastiaandb]

@Amy123  

Your Excelformula is a bit weird. Your criteria for range 1 is set at the title order number and only B3 moves along your rows, it's doesn't make to much sense to me. What is your goal? 

Do you want to sum the next value in column B  if not 0 value AND if Order number is the same AND Booking flag is the same?

In that case the sum of all @ order 2583986 would not be zero.

If you can explain it, i can surely make it for you :-)!

Greetings,

Seb

[Jonathan-Sherman]

Hi @Amy123,

I agree with @Sebastiaandb it's a little difficult to know exactly what you're looking for as the formula doesn't seem to be working logically, but i would be taking an approach along this line:

I've attached my workflow for you to download if needed!

Kind regards,

Jonathan