+ Reply to Thread
Results 1 to 3 of 3

sumifs with index + match

  1. #1
    Registered User
    Join Date
    06-23-2021
    Location
    California
    MS-Off Ver
    2016
    Posts
    2

    sumifs with index + match

    Attachment 737567

    I need a formula that can return the sum of all values based on the certain criteria. Currently, the workbook is done very manually, where I'd have to open the workbook and drag/update the sum formula.
    Cell B9 is adding cells C2:G2 based on the grant date (Since we need future expense amount as of 12/31/2020, it's grabbing 3/31/2021-6/30/021) and cell C9 is adding D2:G2
    Attached Files Attached Files
    Last edited by jeongs1; 06-23-2021 at 02:42 PM.

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,310

    Re: sumifs with index + match

    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

  3. #3
    Registered User
    Join Date
    06-23-2021
    Location
    California
    MS-Off Ver
    2016
    Posts
    2

    Re: sumifs with index + match

    Hello! I've updated and added an excel sheet with how the current process is being done.

+ 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 Sumifs Offset Index Match Match
    By bg_flip in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2021, 06:04 PM
  2. Sumifs or Index Match
    By DavidW262626 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2017, 05:56 PM
  3. [SOLVED] Sumifs match index
    By ovehendrix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2016, 04:17 PM
  4. Sumifs/Index/Match
    By ravidesai in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2016, 02:52 PM
  5. SUMIFS INDEX MATCH or other way?
    By tkrupka in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-09-2016, 03:55 PM
  6. [SOLVED] Sumifs/Index/Match----Please fix
    By Paul Cherian in forum Excel General
    Replies: 11
    Last Post: 09-02-2014, 04:07 AM
  7. SUMIFS, INDEX, and MATCH-- how to fix?
    By sofib09 in forum Excel General
    Replies: 6
    Last Post: 12-13-2010, 11:05 AM

Tags for this Thread

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