Sums

[MissOctober]

I have excel 2010

i have changing rows when a row is inserted.

i have 2 tables.

is there a way i can have my totals formula to stay the same when a new row is inserted.

 

[Aladin Akyurek]

What is your totals formula?

 

[MissOctober]

What is your totals formula?

=average (b53+b54+b55+b58)

= average (d64+d69+ d74+d79+d84+d89)

like i said my rows are changing everytime a new row or rows are inserted

 

[Aladin Akyurek]

=average (b53+b54+b55+b58)

= average (d64+d69+ d74+d79+d84+d89)

like i said my rows are changing everytime a new row or rows are inserted

These formulas will actually sum, not average due to plussing of the relevant cells. They are thus equivalent to:

=SUM(B53,B54,B55,B58)

=SUM(D64,D69,D74,D79,D89)

The totals they give won't change if new rows added for example in between current B53 and current B58.

Does this help?