Excel question, I'm an Rtard

[QueBert]

I'm messing with Excel 2013 on my boss's computer to do a new budget for me. I found a pretty nice built in template called 18 period budget. I've made a bunch of modifications to it and everything worked up until the last one. This should be simple, and it works in the old spreadsheet I made years ago. I'm stumped here and would like some assistance. Here's my dilemma

cell 12 has this formula - =SUBTOTAL(109,[Week 1]) it's my weekly income. I didn't touch this is this how it came from the template.

cell 26 has the same formula - it's for weekly expenses. I Googled the (109 and somewhat understand it. Any ways here is where my problem comes in. I made a cell 27 that's to show my remaining balance after my expenses. I click on the empty cell and press = then click on the total income one, then click - then click on the total expenses and press enter, the formula looks like this =C12 - C26. Super simple, except cell 27 comes up as $0. This is how I always did it in the past, and Googling it unless something has changed in 2013 this is how I should be doing it.

This should be simple as hell but I'm just not understanding why it won't perform the calculation.

Help??

Thanks

 

[Tweak155]

Perhaps you should try the SUM function? It's probably more straight forward. It's just the sum of the cells you choose.

 

[QueBert]

sum's not working either, this means there's a problem somewhere else. The weird part the 2 cells I'm using in the formula just have numbers in them. I guess I need to start from scratch and see what the hell is up. Thanks for the reply

 

[bigboxes]

I guess I need to start from scratch and see what the hell is up.

I was going to recommend that you start from scratch and then see your reply. Trying to edit someone else's work results in errors. Trying to figure out where the bug is can be an endless task. Very unproductive. Sort of like spending all day trying to figure out a computer problem when a fresh install would take care of the issue in fairly short time.

 

[Buddyd]

In the ribbon click on the formulas tab and at the far right click on calculation options and make sure it is set to automatic.

I have had several instances where Excel 2010 and newer will sometimes set calculations to manual by default.

 

[QueBert]

I opened the template again and paid closer attention to what all I was changing, and it's working now. I've noticed in Excel it's easy to screw up just about an entire worksheet with 1 change lol. I'm now going to keep multiple saves so I don't encounter this again. Because when I mess up, I'm nowhere near advanced enough to figure it out, and unfortunately I miss some of my errors until it's too late and I've already made a dozen other changes.

 

[smackababy]

I opened the template again and paid closer attention to what all I was changing, and it's working now. I've noticed in Excel it's easy to screw up just about an entire worksheet with 1 change lol. I'm now going to keep multiple saves so I don't encounter this again. Because when I mess up, I'm nowhere near advanced enough to figure it out, and unfortunately I miss some of my errors until it's too late and I've already made a dozen other changes.

You think it is easy in Excel? Try editing a 50 page document full of bullets, paragraphs, and multilayered lists in Microsoft Word, then letting someone else edit parts of it, and then get it back to edit more. And track changes sucks.

-Yes, I had to edit our EAR install document, let our (incompetent) database guy edit the database install parts, then edit it even more.