Sum sumif of values of matches with multiple columns

[G00DNESS]

My formula works. However, I would like to:
1. If possible, simplify this formula (By not using "+").
2. Prevent errors if there are blanks in Columns DP or DV.


D9 is a formula-driven value (Name) that will appear as a multiple occurrence in Columns DO114:DO469 and in DU114:DU469.
The numeric values in Columns DP114:DP469 and DV114:DV469 are formula-driven as well.

=IF(D9="","",IF(SUMIF('TCH1'!$DO$114:$DO$469,D9,'TCH1'!$DP$114:$DP$469)+SUMIF('TCH1'!$DU$114:$DU$469,D9,'TCH1'!$DV$114:$DV$469)=0,0,SUMIF('TCH1'!$DO$114:$DO$469,D9,'TCH1'!$DP$114:$DP$469)+SUMIF('TCH1'!$DU$114:$DU$469,D9,'TCH1'!$DV$114:$DV$469)))

Thanks in advance for any/all assistance!

 

[DanteAmor]

Try this

=IF(D9="","",SUMPRODUCT(('TCH1'!DO114:DO469=D9)*('TCH1'!DP114:DP469)+('TCH1'!DU114:DU469=D9)*('TCH1'!DV114:DV469)))