+ Reply to Thread
Results 1 to 2 of 2

INDEX MATCH, MATCH and ADD for a dynamic scatter gram chart

  1. #1
    Registered User
    Join Date
    10-26-2014
    Location
    Leavenworth, WA
    MS-Off Ver
    2010
    Posts
    82

    INDEX MATCH, MATCH and ADD for a dynamic scatter gram chart

    HELP, please! My boss needs the following.
    Needs all of the FTEs added together by Schedule Placement and years of service.
    So, the years of service and placement need to match exactly. Then the years of service per Placement and Years of service needs to be added together.
    OUTCOME: To analyze what would happen if the top weighted employees retire in three years.
    I thought that an index, match, match with a sum formula would work, but I don't know how to set it up. OR...is this an IF THEN STATEMENT and SUM? Hmmm...maybe I will try that next.
    The sheet labeled Certified is the one I am working on right now.
    I would appreciate any help on this. THANK YOU!
    Attached Files Attached Files
    Last edited by julesmctavish; 02-11-2016 at 03:26 PM. Reason: Working on spreadsheet

  2. #2
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: INDEX MATCH, MATCH and ADD for a dynamic scatter gram chart

    Hi
    Adjust the range of your real data.
    Use the formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    See the file PRACTICE BUDGET MASTER.xlsx

+ 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. [SOLVED] Dynamic Sheet-Index-Match-
    By FinanceGQ in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-08-2015, 03:03 AM
  2. INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges
    By Andrew-Mark in forum Excel General
    Replies: 3
    Last Post: 02-27-2015, 10:56 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  5. [SOLVED] Dynamic Lookup / Index Match
    By mrgreek in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-03-2013, 05:44 PM
  6. Vba index and match for dynamic range
    By _google in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-20-2013, 10:25 AM
  7. Replies: 5
    Last Post: 02-29-2012, 08:51 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