Sumif and create two new rows

[Stuart_C]

Hi,

I'd like to use a function similar to sumif in excel and output the sum in two new rows as a negative at the bottom based on the Group #.  The account # for the two new rows will be the same as the example.

Input
Group	Account #	Amount
100	965	75
100	947	25
200	875	50
200	658	100

Output
Group	Account #	Amount
100	965	10
100	947	20
200	875	50
200	658	100
100	456	-30
200	456	-150

Thank you,

- Stuart

[JosephSerpis · Accepted solution]

Hi @Stuart_C I mocked up a workflow let me know what you think?

[Stuart_C]

Thank you @JosephSerpis !  This works perfectly!