subtracting/newbie help

ninip

New Member
Joined
Sep 16, 2002
Messages
4
Hi everyone
Could someone please explain to me step by step, I am a newbie to Excel at work.
This is what I need to know how to do.

I have a spreadsheet with the headings across the top:
Name Budget Jan. Feb. Mar. to Dec. Spent Balance

5 Rows with teachers names

What I need is if they start with a budget of $200.00, the balance column needs to say $200.00.
Then every month I put in what they spent and I need the balance column to change automatically.
I hope this is clear and not too confusing.
But I have no idea how to do this so that the balance and the spent column change automatically. So basically subtracting not adding.
Please someone help
Thanks so much in advance
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
680
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1


Name Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Spent Balance


Teacher - 1 200 20 10 10 15 20 20 10 10 0 0 =Sum(C1:N1) =B1-O1

I hope you understand this

GNaga
 

Watch MrExcel Video

Forum statistics

Threads
1,122,717
Messages
5,597,729
Members
414,169
Latest member
Preston_Cleric

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top