I am trying to sum the contents of a table row in order to check whether the table inputs add to 100%, or 1. This is fairly simple to do (see example, columns A & B), but referencing the table columns by name causes issue when additional columns are added and need to be included in the sum also. Additionally, when the table is cleared using an existing macro (the "Clear table" button), the formula will obviously fail.
Is there a way to make the formula always reference the columns from the second one (the first one with a percentage in, after 'date') to the end of the table? No matter the number of columns, or what they are called? I don't mind this not being in a Macro like the other functions, but to allow the other macros to work and columns to be added/deleted would be very helpful.
Any help is much appreciated!