Close
Results 1 to 9 of 9

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Grand Master Know It All crays's Avatar
    Join Date
    Feb 2010
    Location
    Live-Aurora Work-Golden
    Posts
    4,260

    Default

    Quote Originally Posted by CavSct1983 View Post
    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!

    Click image for larger version. 

Name:	excel1.PNG 
Views:	18 
Size:	9.0 KB 
ID:	73164Click image for larger version. 

Name:	excel2.PNG 
Views:	16 
Size:	8.7 KB 
ID:	73165
    Oh, sure. Get all fancy with visual aids and catchy descriptions...
    Comply in public, Conduct in private.

    FEEDBACK

  2. #2
    Recognized as needing a lap dance
    Join Date
    Jan 2010
    Location
    SW Missouri
    Posts
    5,540

    Default

    Quote Originally Posted by crays View Post
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •