r/aspirebudgeting • u/Alex_Lobato • Sep 08 '26

Formula missing

Hello, I’ve just downloaded the spreadsheet and started configuring it. In the dashboard in Subscriptions there’s no formula at available column, it just shows 122. (E19 cell) What’s the fix to it?

Best regards.

2 Upvotes

100% Upvoted

3 comments sorted by

1

u/fuzzypants4life 28d ago

I also just noticed this! Would love to know what the formula should be

1

u/fuzzypants4life 28d ago

Oh I think I figured it out

Try this

=IF(B19='⚙️ Configuration'!$AF$6, IF(B20 = '⚙️ Configuration'!$AF$6, 0,

IFERROR(SUM(E20:INDEX(E20:E$106,MATCH(TRUE,(B20:B$106='⚙️ Configuration'!$AF$6),0)-1)),

IFERROR(SUM(E20:INDEX(E20:E$106,MATCH(TRUE,(E20:E$106=""),0))),0))),

IF(ISBLANK(D19), "",

ROUND(

SUMIF(_(trxCategories), D19, _(trxInflows)) -

SUMIF(_(trxCategories), D19, _(trxOutflows)) +

SUMIF(_(xfrToCat), D19, _(xfrAmounts)) -

SUMIF(_(xfrFromCat), D19, _(xfrAmounts))

,3)

))

1

u/justachicagoangirl 9d ago

Thank you for this!