Thank you for taking my question!

First, I work for a non-profit. A campaigner is someone that is helping to
solicit donations. We have 40 campaigners and each campaigner is assigned
prospects. So say rows 2-15 are bob's prospects then row 16 is where his
totals are. The formulas then would be the sum of 2-15, say, =sum(E2:E15)
and the total of them is in E16. Then if I try to add another row somewhere
in there, it messes up that formula and all the others from there on down.
Please help!