Working around #CIRCULAR REFERENCE error to use the same formula multiple times?


I have this formula:

=AVG(COLLECT(IIQ:IIQ, [SE Manager]:[SE Manager], "John Lennon", [Row Number]:[Row Number], @cell >= 27))

I would like to use it in multiple rows. However, I get a #CIRCULAR REFERENCE error when I do, because it is used in the same column it references, so including more than 1 instance of that formula in the same column gives an error (you're allowed only 1 #CIRCULAR REFERENCE error).

How can I work around this?

Notice that the whole formula needs to only count rows 27 and above.

Can I use some kind of helper column workaround?

Or perhaps changing IIQ:IIQ to somehow only target rows 27 and above?