Table Column Calculations

I have a table in Acrobat 2017 form.  There are 2 columns for payments to utility vendors.  One for Gas One for Electric.  What I am trying to do is total each column then sum the 2 column totals.  I can create calculations  for the 2 columns alright then sum the 2 totals, but it doesn't work like I want it to.  The first column imports payments from our database, the second column payments have to be entered by our caseworkers.  The data imports fine into tcolumn 1 of the table but does not calculate until I enter an amount in the second column then all of the calculations happen.  If nothing is entered into the 2nd column no calculations happen so if the caseworker doesn't have a payment for column 2 all of the totals stay zero.  Can this operation be done with the "Value is the sum" calculation or will I have to use Java Script to get it to work like I want it.  I don't know how to write java script.  Thanks.