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!
Last edited by julesmctavish; 02-11-2016 at 03:26 PM.
Reason: Working on spreadsheet
Re: INDEX MATCH, MATCH and ADD for a dynamic scatter gram chart
Adjust the range of your real data.
Use the formula See the file PRACTICE BUDGET MASTER.xlsx
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By FinanceGQ in forum Excel Formulas & Functions
Last Post: 07-08-2015, 03:03 AM
By Andrew-Mark in forum Excel General
Last Post: 02-27-2015, 10:56 PM
By sfike in forum Excel Formulas & Functions
Last Post: 04-30-2014, 02:42 AM
By Underling in forum Excel Formulas & Functions
Last Post: 11-08-2013, 10:29 PM
By mrgreek in forum Excel Formulas & Functions
Last Post: 04-03-2013, 05:44 PM
By _google in forum Excel Programming / VBA / Macros
Last Post: 02-20-2013, 10:25 AM
By rain4u in forum Excel Programming / VBA / Macros
Last Post: 02-29-2012, 08:51 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1