+ Reply to Thread
Results 1 to 3 of 3

Trying to compare actual results to budget with multiple IS items per Budget Line

  1. #1
    Registered User
    Join Date
    03-01-2010
    Location
    Portland, OR
    MS-Off Ver
    Office 365
    Posts
    57

    Trying to compare actual results to budget with multiple IS items per Budget Line

    Currently I am trying to create a budget to actual analysis when there are often multiple Financial Statement line items per a single line in the budget. For instance on for the Plant Supplies Budget Item, there will be Safety Supplies, Misc Supplies, Plant Supplies - Drums, and small tools. Using some kind of formula would then add up all those accounts to compare with the given Budget Line Item.

    Ideally I would want a supporting tab with all the different Financial Statement Accounts mapped out to the corresponding Budget Line Item which are then summed on the main page for review. This would be much easier to maintain as opposed to having a six argument formula.

    Basically basically if the budget line equals this, then sum certain IS accounts that are mapped on the supporting page.

    is what I am describing realistic at all?
    Last edited by ppilot; 03-13-2017 at 07:32 PM.

  2. #2
    Registered User
    Join Date
    03-01-2010
    Location
    Portland, OR
    MS-Off Ver
    Office 365
    Posts
    57

    Re: Trying to compare actual results to budget with multiple IS items per Budget Line

    After thinking about this more, I guess my question can be narrowed down this: Can some form of sum formula be setup where the criteria is defined by a range of cells?

  3. #3
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,570

    Re: Trying to compare actual results to budget with multiple IS items per Budget Line

    If you attach a workbook (not pictures) with some data and the expected output it will be much easier to help you.
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Nested IF statement to show under budget, within a % of budget, over budget
    By clafleur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2015, 10:36 AM
  2. Replies: 1
    Last Post: 10-14-2015, 01:32 AM
  3. Replies: 2
    Last Post: 10-13-2015, 07:58 PM
  4. [SOLVED] using sumifs() to compare cumulative totals for actual versus budget based on financial pe
    By Woodstock in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-12-2012, 08:26 AM
  5. Actual as a % of Budget formula
    By nier06 in forum Excel General
    Replies: 1
    Last Post: 02-13-2012, 01:19 PM
  6. Bar Graph - Compare Budget to Actual
    By zjenni01 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-30-2011, 11:19 AM
  7. [SOLVED] Budget vs. Actual
    By Stanley in forum Excel General
    Replies: 0
    Last Post: 12-16-2005, 05:10 PM

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