Results 1 to 7 of 7

Sumifs / index / match in another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-06-2017
    Location
    Europe
    MS-Off Ver
    2013
    Posts
    123

    Sumifs / index / match in another sheet

    Hello all,

    I need a little help with a Sumifs + Index + Match formula, in order to do this:
    - look for "ABCDEFGH" (Sheet2!A7) and "WEEK 37 2019" (SHEET2!G3) in sheet1 and make sum between the values in Sheet1 column F - for week 37. (see attachment)

    If you have any free time in order to help, would be great.
    Thank you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Sumifs match index
    By ovehendrix in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-18-2016, 04:17 PM
  2. [SOLVED] Help With SUMIFS / INDEX / MATCH
    By jpetrini888 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-17-2016, 10:12 AM
  3. Sumifs/Index/Match
    By ravidesai in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2016, 02:52 PM
  4. SUMIFS INDEX MATCH or other way?
    By tkrupka in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-09-2016, 03:55 PM
  5. [SOLVED] Index/Match/Sumifs?
    By overbomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-12-2016, 06:07 AM
  6. [SOLVED] Sumifs/match/index?
    By mstoto in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-14-2014, 09:23 AM
  7. [SOLVED] Sumifs/Index/Match----Please fix
    By Paul Cherian in forum Excel General
    Replies: 11
    Last Post: 09-02-2014, 04:07 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