+ Reply to Thread
Results 1 to 2 of 2

Complicated multi workbook countifs help

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    Greater NYC Area
    MS-Off Ver
    Excel 2010
    Posts
    84

    Complicated multi workbook countifs help

    Good morning,

    I'm working on a project to compare an item's performance against a set benchmark. Each item is listed in categories and then subcategories based on Year, Geography, and strategy (type). All of the performance data is in one workbook, and the benchmarks are in a separate workbook. I need to come up with a formula which will match an item against its specific benchmark type and then return the number that fit first fit the criteria of being in the top quartile, as well as the number that are in the top half.

    I've been struggling with this for a little while and have tried several different approaches including pivot tables and countifs(), but haven't had any luck being able to match up all the subcategories, so any thoughts would be appreciated.

    Please see attached. I need to fill in the Yellow cells. I gave a few examples. Let me know what questions you have, and thank you for your time!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Complicated multi workbook countifs help

    It would be a good start adding all data in 1 file.

    After that tell us how you manualy would achieve the results.

    If you explain well, maybe a forummember will adjust the formula's to the cells.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Complicated COUNTIFS
    By swoop99 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-20-2013, 10:50 AM
  2. Replies: 5
    Last Post: 05-03-2012, 12:13 AM
  3. Excel 2007 : Countifs linking to another workbook
    By ncurran217 in forum Excel General
    Replies: 5
    Last Post: 01-29-2012, 06:55 PM
  4. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  5. Replies: 6
    Last Post: 02-21-2009, 08:13 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