I have built an evaluation scorecard and want to be able to allow
others
to use it without always having to do it for them as they know nothing
about formulas. I have multiple rows that have a seperate weight factor

for each and a score of 1-5 for each. These roll down to a total box
that does all the calculations.  If I delete of add a row I get the
#REF in my totals.Is there anything I can do to make the formula update

with the addition or subtraction of the rows?  Thank you in advance.