Sumifs function

Question

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 NumberAccounting colour amountBooking flag2561895-218,599Closed2561895218,599Closed2571480-7,627,360Closed25714800Closed25714807,627,360Closed25714800Closed2583986-152,859Closed25839860Closed2583986-13,500Closed

Jonathan-Sherman · Answer

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

20211109 - SumIFCalculation.yxmd

Sebastiaandb · Answer

@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

AncientPandaman · Answer

Solved: SUMIF Function - Alteryx Community

add a join tool later.