sum range with column priority

[288enzo]

Hi all,

I have two columns of numbers, one is an "estimate" and another is "actual". I'm trying to add up the total giving any number in the actual column priority. As an example:

Estimate	Actual
-$14.00
-$25.00	-$28.00
$1,000.00	$1,000.00
$961.00

Should equal $958.00

Estimate is D7:D16
Actual is E7:E16

Thanks!

 

[288enzo]

I came up with this:

=SUM(FILTER(D7:D16, ISBLANK(E7:E16)))+sum(E7:E16)

Works, are there any unforeseen issues with it?