SUM function creates circular ref if first or last rows are moved
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
|