I work at a school that does everything manually for the cafeteria accounts i am wanting to make my own account sheets to make it easier on myself and be more efficent. I am goint to attach a file to see how i have it set up.
Here is what i need:
D2 is the begining balance( can be 0 or negative) need this amount to show in total before i begin adding and subtracting.
Deposits in B and Charges in C. I need the Deposits to add to the Total and have the Charges subtract from the Total.
Total is E35.
I am new to all of this and am not really sure about how to use the formulas and stuff.
all the other worksheets i use in excel are already made for me i just put in the info
if someone could help that would be great!