First off, thanks to Mynda for the amazing videos to help us learn.
I am using the Ultimate Budget and Interactive Dashboard template and so far so good, except...I have watched hours of tutorials and can not seem to do what seems like it should be relatively easy so I must be missing something.
I would like to insert a sheet that contains the Sub-Categories in Column A, and the current balance I have in each of those categories in Column B (think "envelope budgeting" system). I would like the balances to update based on inputs made in the Transactions tab (table). At any given moment I would like to be able to see how much money I have in my Groceries budget, for example.
I know this is possible, and perhaps I missed this info in one of the dozens of tutorials I watched but after 30+ attempts at doing this I am not having success. I have slowed the videos down to the point that Mynda sounds drunk, and after repeated failures...I want to get drunk..!! LOL
Any help would sure be appreciated. Thank You!
Did you look into the SUMIF and SUMIFS functions?
IF you did and couldn't figure it out, it would be easiest for us to help if you upload your file.
Thank you. I believe I got this sorted.