Try to use Offset function to create a dynamic range in your formula, so
when you delete/insert rows, the range automatically changes.
Example (try this by yourself):

In Cell B11 type the following formula, which sums all data from B1 till
B10 -

=SUM(OFFSET(B11,1-ROW(B11),0,ROW(B11)-1,1))

You can delete/inserts rows between B1 and B10.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
wrote in message
oups.com...
I have built a 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.