#N/A error message for Current Assets, Current Liabilities and Net Worth

Google Sheets
, ,
1

I started using the Foundations template in 2024, and decided to use the same Foundations template for 2025.

In the “Categories” tab, I simply added 12 columns for 2025.

I think it may have broken something in the template, because in the “Spending Trends” tab, my Current Assets, Current Liabilities and Net Worth are showing an error message: #N/A

Formula for Current Assets (cell B5):
=SOMME.SI.ENS(INDIRECT($AA$31),INDIRECT($AA$29),“Asset”,INDIRECT($AA$30),“<>Hide”)

Formula for Current Liabilities (cell C5):
=SOMME.SI.ENS(INDIRECT($AA$31),INDIRECT($AA$29),“Liability”,INDIRECT($AA$30),“<>Hide”)

Net Worth =B5-C5

How do I fix the formulas?

Thank you.

2

This looks like a foreign language :thinking:

Here are those formulas in my Spending Trends sheet:
cell B5:

=sumifs(INDIRECT($AA$31),INDIRECT($AA$29),"Asset",INDIRECT($AA$30),"<>Hide")

cell C5:

=sumifs(INDIRECT($AA$31),INDIRECT($AA$29),"Liability",INDIRECT($AA$30),"<>Hide")
1 Like
3

Hello Mark, my settings are in French. The formulas themselves seem to be fine, but where they get their data seems to be broken. I don’t know how to fix it.

4

Does hovering over the #N/A error provide additional info?

5

Hi Kimberly,

How did you add your 2025 columns to the Categories sheet?

Did you add them after the 2024 columns or before? They should be in date order, 2024 followed by 2025. I have several years of data in my Categories sheet, but “hide” the columns for previous years.

Did you copy/paste the 2024 columns? This would preserve the formatting of the cells. I usually do this and then adjust the budget numbers for the new year where appropriate.

Here is a help article about getting things set up for a new year in Tiller: How do I get my budget ready for the new year? | Tiller Help Center

Martha

6

Seems like the Assets/Liabilities/Net Worth #N/A errors would be more likely related to the Accounts tab (or Balance History, since that’s the source for Accounts), than it would be to the Categories tab :thinking:

Spending Trends tab reference for the formulas in question:

image
image416×114 4.98 KB

7

Only what I pasted initailly on Jan 9.

8

Hi Martha, I did indeed add 12 columns for 2025 after 2024, but I don’t recall if I copied and pasted everything as you suggested. I’ll take another look at the doc you suggested; thanks!

1 Like
9

Hi Mark, I have a balance history tab, but not an Accounts tab. Would you recommend I start a fresh Tiller sheet and copy everything into it, or can I manually add an accounts tab?

10

Hi Kimberly, you should be able to restore the Accounts tab via the Tiller Money Feeds extension’s Templates selection.

Once you have the Accounts tab in your spreadsheet, select all the different accounts row-by-row in the Account column and assign them a Group name that makes sense for your usage.

image
image591×666 29.7 KB