New and need assistance with a summing and balancing problem (I think)

[scooter99]

So I'm developing this workbook for work. The management wants to have a FTO (Flexible Time Off) balance sheet. They want to have a number to start (fixed), and then under it a balance remaining cell. Under those, is a table that has the months and days in it. They want totals for the months and totals for the days. I've done auto sum for these. My problem is in the "remaining balance" area. I want to take the "beginning balance" and subtract the amounts in the table from it, to give me my "remaining balance".

I'm still learning ecxel and have gotten a new job, so I know I'll be using it more, so I wanted to subscribe here to be able to ask questions if I get stuck on something etc. I'm not familiar with all the terminology, or I'd have searched to look for this.

Attached is the file I'm working on. In the "Remaining Balance" cell I've entered the formula as =SUM(B2)-(B19:AF19)

The problem I'm having is that it will see B19, and subtract it in the remaining balance cell. But it will not recognize C19-AF19.

What am I doing wrong please?

[scooter99]

I got it. I did it backwards. The formula is =(B2)-SUM(B19:AF19) I tried it and it works.

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.