On Jan 2, 1:33*pm, Alan Smith
wrote:
When I use the following formula in N741-Z788 everything appears
to be fine:

=SUMPRODUCT(SUBTOTAL(3,OFFSET($G$6:$G$709,
ROW($G$6:$G$709)-MIN(ROW($G$6:$G$*709)),0,1)),
--($G$6:$G$709=$G741),N$6:N$709)

When I try to use the same formula in AC741 (the only change is
to the N$6:N$709 reference, which is now AC) I get a circular
reference in N742. Any idea why that would happen? I feel like I'm
missing something easy here but I can't see it.

I suspect there is more to this than meets the eye -- literally. I do
not get an error when I cut-and-paste the above formula into
N741:Z788, then copy-and-paste N741 into AC741.

Of course, I do not have the data or formulas in the other cells that
you have. I suspect that therein lies the problem -- perhaps a
reference to AC741. Can you find it by selecting AC741 and using
ToolsFormula AuditingTrace Dependents?

(I have no idea why would get a circ ref "in" N742 when you copy-and-
paste the formula into AC741, if the N$ references are indeed changed
to AC$, as you say.)