Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.

First, rather than using cell references, you need to use structured references. This means that you can use the column headers in your table. Second, if you use the same formula as in regular ...