I’m working on a 'dynamic form’ with an expandable table (i.e. the user presses a button to add a new row), there are cells in each row for beginning month & ending month, plus an autocalc total field containing the formula: “ending – beginning +1” (which accurately calculates total months e.g. Jan-Dec = 12 months). There is also a ‘total months’ field in the footer which sums the row ‘total’ cells. The problem I have is that the user could add a blank row throwing off the total cell in the footer. Any suggestions to accomplish my goal of presenting accurate total in footer while ‘idiot proofing’ the form?
