Love the template, but there appears to be an error in the formula for the specific category breakout:
=IF(ISBLANK(I9),"",SUMPRODUCT(Transactions[Amount]*(Transactions[Category]=$I$6)*(Transactions[Date]>=$E$2)*(Transactions[Date]<=$G$2)*(Transactions[Description]=$I9)))
Each reference array works individually when tested, but is SUMPRODUCT the correct function?
That’s odd. That formula is definitely working for me. Is it possible you don’t have valid dates in E2 or G2? Is it possible the Transactions/Amount column isn’t formatted as numbers or has some cells with text in them?
So, I have tested each argument/array in the formula and they all work individually. (Column F shows that it finds the description value further down the page.) However, the formula keeps failing. I am stumped!
NVM! I traced the error to a single corrupted cell on row 2910(!) and fixed it! Oyi!
Glad you got it sorted. Sometimes its something buried like that. Nice debugging.
Randy
Hi Randy,
I am a new Tiller user, and just added the Category Tracker worksheet v 1.62 to my Foundation Template. The pie chart function works as expected at the category level, ie, selecting 5, 10, 15 categories to chart in the drop down menu box (in cell G6) all works. However when selecting “group” (in cell E6), the pie chart then reflects ALL groups with expense, regardless of the count # selected in cell G6. Screenshot below…
Not sure if this is already a known issue with a solution…I didn’t see anything searching thru the comments here. I use Excel 2024 for Mac. As noted, everything else works as designed.
Thanks for the assistance
Charlie
