How do I sum results of two if statements in the same cell?

I'm looking to have the results of two If statements calculated and added in the same cell. I'm getting #VALUE! error.

=SUM(IF(ISERROR(GETPIVOTDATA("Sum of CHARGES",'Ship City'!$A$3, "ship_city",$B$7,"carrier_type",$A$27, "INV_month_id",D$6,"INV_year_id",$D$5,"Company Name",$B29)),"",GETPIVOTDATA("Sum of CHARGES",'Ship City'!$A$3, "ship_city",$B$7,"carrier_type",$A$27, "INV_month_id",D$6,"INV_year_id",$D$5,"Company Name",$B29))+IF(ISERROR(GETPIVOTDATA("Sum of CHARGES",'Recipient City'!$A$4, "recipient_city",$B$7,"carrier_type",$A$27, "INV_month_id",D$6,"INV_year_id",$D$5,"Company Name",$B29)),"",GETPIVOTDATA("Sum of CHARGES",'Recipient City'!$A$4, "recipient_city",$B$7,"carrier_type",$A$27, "INV_month_id",D$6,"INV_year_id",$D$5,"Company Name",$B29)))