Help with Google Spreadsheets

[CS1983]

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!

[KevDen2005]

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!

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

[CS1983]

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.

[KevDen2005]

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.

[KevDen2005]

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

[crays]

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!

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

[KevDen2005]

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

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