hello
im working on a spreadsheet with rows of data that need to be dragged and
dropped to various categories. each category has it's own subtotal.

if i drag and drop either the first or last row that the subtotal
calculates, i get a circular reference error.

is there a way to maintain the integrity of my subtotals and still be able
to freely move the rows in each category?

i tried $col$row as a sticky but that did not work. please advise