Help with Google Spreadsheets

I'm trying to keep track of an account that has money put in it each year and want to subtract from that number each time something is purchased. So basically doing subtraction for the entire column. I've done a lot of searching and all I can come up with is how to subtract two numbers only, not keep it going until zero.

how many rows and columns are you using? Are you entering each deduction individually?

An easy way in excel (I am assuming the google version is similar) would be to place starting amount in cell A1, and this formula in cell A2: =A1-SUM(B:B)
Enter your deduction amounts in cells in column B (B1, B2, B3, etc.), and the remaining balance will be calculated and shown in cell A2

Does that make sense?

ETA: The above functionality is the same in Google Sheets.

Use a colon to establish a total for expenditures and then subtract that from the beginning balance.

=SUM($firstexpenditure:$lastexpenditure )

Example: =SUM(B2:B5)

Note: the final value can be a blank cell (treated as a 0). You need to make sure the spreadsheet values for output are (-), or you will need to (-) instead of (+) the 2nd example.

For beginning balance minus expenditures:

=SUM($beginningbalance+$expenditures)

Note: Remember, $expenditures is a negative value, hence X+(-Y) = X - Y

Example:
=SUM(B1+B6)

PS: just having fun with the names in the column. Don't take offense!

Attachment 73164Attachment 73165

Quote:

---

Originally Posted by CavSct1983

Use a colon to establish a total for expenditures and then subtract that from the beginning balance.

=SUM($firstexpenditure:$lastexpenditure )

Example: =SUM(B2:B5)

Note: the final value can be a blank cell (treated as a 0). You need to make sure the spreadsheet values for output are (-), or you will need to (-) instead of (+) the 2nd example.

For beginning balance minus expenditures:

=SUM($beginningbalance+$expenditures)

Note: Remember, $expenditures is a negative value, hence X+(-Y) = X - Y

Example:
=SUM(B1+B6)

PS: just having fun with the names in the column. Don't take offense!

Attachment 73164Attachment 73165

---

I feel like I should not spend that amount on drop guns....someone that is good with the economy help me out here

Ha, it's the same Sum formula but with negative numbers. I'm retarded.

Quote:

---

Originally Posted by KevDen2005

I feel like I should not spend that amount on drop guns....someone that is good with the economy help me out here

---

No no no. You're awful at embezzlement. That's not what you spend on drop weapons, that is what you claim you spent. You'd make a horrible politician.

Quote:

---

Originally Posted by CavSct1983

No no no. You're awful at embezzlement. That's not what you spend on drop weapons, that is what you claim you spent. You'd make a horrible politician.

---

I received fairly good grades in all my political classes except public finance...now I know why.

Quote:

---

Originally Posted by CavSct1983

Use a colon to establish a total for expenditures and then subtract that from the beginning balance.

=SUM($firstexpenditure:$lastexpenditure )

Example: =SUM(B2:B5)

Note: the final value can be a blank cell (treated as a 0). You need to make sure the spreadsheet values for output are (-), or you will need to (-) instead of (+) the 2nd example.

For beginning balance minus expenditures:

=SUM($beginningbalance+$expenditures)

Note: Remember, $expenditures is a negative value, hence X+(-Y) = X - Y

Example:
=SUM(B1+B6)

PS: just having fun with the names in the column. Don't take offense!

Attachment 73164Attachment 73165

---

Oh, sure. Get all fancy with visual aids and catchy descriptions... [Flower]

Quote:

---

Originally Posted by crays

Oh, sure. Get all fancy with visual aids and catchy descriptions... [Flower]

---

A powerpoint with no pictures and just black and white text for about 100 slides would have been right up my ally.