Add values in one column where there are values in another column

[ericachae]

Hi!

I'm trying to create workflow which will result below...

I would like to sum client amt where our amt is available..

<BEFORE>

Client AMT	Our AMT	After Our AMT
$380	$360	$240
$300		$290
$300	$280	$270
$100	$100	$90

<AFTER summarize tool>

sum of Client AMT	sum of Our AMT	sum of after Client AMT	sum of after our AMT
$780	$740	$1,080	$890

Thank you in advance...

[ed_hayter · Accepted solution]

I think i have what you want

[binuacs · Accepted solution]

@ericachae one way of doing this

[ericachae]

all the answer came so quickly and perfectly worked.

Thank you all