#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