+ Reply to Thread
Results 1 to 2 of 2

Formula to identify the result column base on the given criteria (I,e month)

  1. #1
    Registered User
    Join Date
    06-18-2018
    Location
    Manila, Philippines
    MS-Off Ver
    Microsoft 2013
    Posts
    8

    Formula to identify the result column base on the given criteria (I,e month)

    Hi Guys,

    Good day!

    Hope you can help me again.


    I'm currently doing a dashboard where i need to summarize the figures based on the given criteria (including month) however my problem right now is my sum range (months) are in horizontal form.
    I'm thinking to use INDEX+MATCH but no clue on how to show the result (column).

    Thanks!
    Attached Images Attached Images

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,526

    Re: Formula to identify the result column base on the given criteria (I,e month)

    Attach a sample workbook rather than the picture of it and we can help from there.

    BSB

+ 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. How to identify the cells from the sumproduct formula result
    By CachimJ in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-29-2018, 01:22 PM
  2. excel formula, two criteria, 3rd column result
    By cjdstephenson in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-09-2015, 10:12 AM
  3. [SOLVED] finding a result of a specific text base on the next day result
    By top00001 in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 10-15-2014, 02:01 AM
  4. [SOLVED] Splits Data base on Column Criteria
    By markverdad in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-09-2014, 09:57 AM
  5. excel formula to find the result from the 3 column with criteria
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-26-2013, 05:09 AM
  6. [SOLVED] Excel formula from looking the base date and convert into desire result
    By PRADEEPB270 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-17-2013, 11:43 AM
  7. [SOLVED] Identify month in a period and run a formula
    By M in forum Excel General
    Replies: 4
    Last Post: 08-09-2005, 08:05 AM

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