SUMIFS on scattered data

[ppatane]

In the accompanying data table, in the Totals column, I need to add up the Amount column for each instance of the combination of the Invoice and Payee columns being the same. Invoice A has the same Payee for each row, so those got added together. Same thing for Invoice B. Invoice C has 2 rows with the same Payee and 1 is different, so the 2 rows get totaled and the third is its own total. Invoice E has 3 the same and 1 different.  How can I leave the data in its current order and yet do the Alteryx equivalent of Excel's SumIfs?

The formula in Totals looks like this: =SUMIFS([Amount],[Invoice '#],[@[Invoice '#]],[Payee],[@Payee])

[Felipe_Ribeir0 · Accepted solution]

Hi @ppatane 

You can summarize by invoice/payee, and join the data back:

[ppatane]

Grazie! Grazie!  I'll add a count column to put it back in it's original order.