sumation function

[toby]

hi.
i 've a column of data whcih is the quantity of each items. how can i fix
the area of sum function (ie. $B$12 - $B$32)? so when i insert new row of
data, the sum area **would not** change to (B12-B33) automatically?
anything that i can do to remain the sum area unchange?
thx in advance

Toby

 

[Frank Kabel]

Hi Toby
one way:
=SUM(INDIRECT("$B$12 - $B$32"))

 

[toby]

it works
thx Frank

Hi Toby
one way:
=SUM(INDIRECT("$B$12 - $B$32"))