•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Formula works in most of the cells ant not others
Our take
It sounds like you're encountering a common issue with your budget spreadsheet, where the running total formula behaves inconsistently across different sections. This typically occurs when the formula relies on certain cells being populated. If a cell is empty, it may disrupt the calculation for the running total, causing it to not display correctly.
I downloaded a budget excel that was basicly what i was looking for. I coped it 13 times in the work sheet one for each month and 1 for a yearly total. The yearly one is running a current total for the year for what was done so far. My issue is that most of the cells this will work in but there is one section it will not do a running total for unless i have an amount in every cell for the 12 months. Any ideas what could be the issue
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#AI formula generation techniques#formula generator#excel#budget#running total#formula#yearly total#worksheet#monthly#cells#current total#amount in every cell#total for the year#issue