Sumif two colomns to ignore if a value is present

I have two colomns with $ amounts in it, a forecast and an actual.
I want to sumif the forecast colomn but if there is an amount in the actual I want the sum of that number rather than the forecast one.

Example

Forecast Actual


$183,000 $187,000
$170,000 $194,760
$225,000
$1,891 $2,000
$64,000
$20,500 $20,287

Current Sumif formula =SUMIFS($AH$17:$AH$190,$J$17:$J$190,"Red",$B$17:$B$190,"Company")
Produces just the sum of the Forecast colomn. I want the actual Sum to Sum the Actual (if there is one) + the sum of the Forecast if there is none in the Actual.
So the formula should produce the result of the items in bold above.

Any ideas?

Would the result you are looking for in your sample be $664,391.00?

Ok, had my columns mixed up. I was going to suggest using sumproduct. This returns that result as well.

=SUMPRODUCT((B2:B7 = "")*(A2:A7))+SUM(B2:B7)

thanks, but that doenst solve my issue with my other criteria.
I want the sum of those colomns if two other conditions are met (see post 1)

Which Range in your formula in Post 1 represents Actual and which represents Formula?

to try and make this clear (sorry for going a roundabout way) here is a more detailed example

Source Forecast Actual Likelihood

Company $183,000* $187,000* Red
Company $170,000* $194,760* Red
Other $225,000* Green
Other $1,891 *$2,000* Green
Company $64,000* Red
Other $20,500 *$20,287* Red
Company $5,000 $7,000 Red

so again the formula is to use Actual where possible, and only for the lines where it is "Red" under likelihood and "Company" in the first colomn. Hopefully my original formula in post 1 makes more sense now.

Daddylonglegs i get a value error on your formula

Marcol that seems to work!! testing now.....

Marcol that is wonderful. thank you for your work. Before i assign this thread as solved could I ask one more favour and that is if you add another colomn to your sheet called Status (Colomn E for example) and if any cells in E are either "NTU" or "Dead" they are to be ignored/omitted from the sum?

Possible statuses are as follows
Quoted ****
Bound ****
NTU
WIP ****
Modelling ****
Declined
Non-Renewed
Extended

only the ones withe asterixs on them are to be included in the sum ?

thanks again for your help Marcol, but i would really like to be able to do this in the formula? Is it possible?

absolutely brilliant thank you all

thanks Marcol!