"Array result was not expanded" error

Google Sheets
1

Have a basic need problem to fix an error code causing no updates to Monthly Budget Template, H16 space.

I can’t fix this and am ready to go to Quicken unless someone can help me.

=arrayformula(if(isblank(B16:B),iferror(1/0),if(counta($N$16:$N)=2,if(row($G16:$G)-row($G$16)>=max($N$16:$N),F16:F-G16:G,G16:G-F16:F),if($Q$16="Income",G16:G-F16:F,F16:F-G16:G))))

Error Array result was not expanded because it would overwrite data in F20.

2

That error usually means that you entered data manually into a cell that is being filled with an ARRAYFORMULA(). I’d delete whatever is in cell F20 and see if it starts working again for you.