# "Array result was not expanded" error

**URL:** <https://community.tiller.com/t/array-result-was-not-expanded-error/17377>\
**Category:** Google Sheets\
**Tags:** troubleshooting\
**Created:** [April 5, 2023, 5:45pm UTC](https://community.tiller.com/t/array-result-was-not-expanded-error/17377 "2023-04-05T17:45:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![marylongfellow](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/marylongfellow/32/12170_2.png) [@marylongfellow](https://community.tiller.com/u/marylongfellow)\
**Post date:** [April 5, 2023, 5:45pm UTC](https://community.tiller.com/t/array-result-was-not-expanded-error/17377/1 "2023-04-05T17:45:48Z")

</div>

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`.

---

<div class="post-metadata">

**Author:** ![randy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/randy/32/16_2.png) [@randy](https://community.tiller.com/u/randy)\
**Post date:** [April 5, 2023, 9:15pm UTC](https://community.tiller.com/t/array-result-was-not-expanded-error/17377/2 "2023-04-05T21:15:48Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![thevioletlevy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/thevioletlevy/32/15715_2.png) [@thevioletlevy](https://community.tiller.com/u/thevioletlevy)\
**Post date:** [June 4, 2026, 3:19pm UTC](https://community.tiller.com/t/array-result-was-not-expanded-error/17377/3 "2026-06-04T15:19:57Z")

</div>

I had the same issue in my Category Tracker page with cell B21, under “Type / Group” for no apparent reason. It looked like the cell was empty, but after reading this solution, I selected the cell and hit delete anyway, and it fixed it. Maybe there was an accidental space typed in it? ¯\_(ツ)\_/¯

---

<div class="post-metadata">

**Author:** ![deniseskidmore](https://sea2.discourse-cdn.com/flex020/user_avatar/community.tiller.com/deniseskidmore/32/25128_2.png) [@deniseskidmore](https://community.tiller.com/u/deniseskidmore)\
**Post date:** [June 12, 2026, 1:17am UTC](https://community.tiller.com/t/array-result-was-not-expanded-error/17377/4 "2026-06-12T01:17:47Z")

</div>

If you mess up a sheet badly enough, rename it for backup and then import it again from the Tiller Money Feeds extension. A lot of these sheets run on automated data fills and are not designed for manual entries. Stick to filling in the green background cells and Transactions sheet until you get the hang of it.