+ Reply to Thread
Results 1 to 4 of 4

Tracking expenditures by budget lines

  1. #1
    Registered User
    Join Date
    07-21-2008
    Location
    NYC
    Posts
    2

    Smile Tracking expenditures by budget lines

    Thanks for this great forum.

    I am trying to track expenditures by budget lines. What I have is (i) totals for various budget line expenditures, (ii) a drop down menu to choose which budget line is being charged and (iii) a place to input the value of each expenditure.

    How do I enable my spreadsheet to do the following:
    once a budget line is chosen from the dropdown menu, add the expenditure value input to the total amount of the particular budget line.

    I have attached a sample worksheet setup. I appreciate any help you can provide.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    INDEX/MATCH or SUMIF

    I am not sure what you want, so here are two alternatives (see encl.)
    //Ola
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-21-2008
    Location
    NYC
    Posts
    2

    Thanks Ola!

    The formula =SUMIF($A$6:$A$51,H20,$B$6:$B$51) is exactly what I was looking for!

    Many, many thanks.

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    ...

    Thanks for the feedback
    Ola

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1