+ Reply to Thread
Results 1 to 4 of 4

Sumifs on lookup / index match

  1. #1
    Registered User
    Join Date
    01-14-2013
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    6

    Sumifs on lookup / index match

    Hi people

    I'm having a bit of trouble with a formula... I'm not even 100% what to use to attack it properly...
    I have a variable date range and am wanting to pull back the total value of a product in that range but i need to look the product up from it's code on the forecast review sheet.
    Cell H5 downwards are pulling the correct data but they need to be looking at the code in column F and looking it up in the "Customer forecast data sorted" sheet.

    If anyone has any ideas or can see where i'm going wrong I'd really appreciate the help!

    Many thanks
    Adam
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Sumifs on lookup / index match

    In H3, then drag down
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-14-2013
    Location
    UK
    MS-Off Ver
    Excel 2016
    Posts
    6

    Re: Sumifs on lookup / index match

    Thank you for your help!
    You're an absolute star!
    This has been driving me crazy

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Sumifs on lookup / index match

    Welcome. Pl mark the thread solved.

+ 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. [SOLVED] Index Match Sumifs Maybe?
    By TreeLife in forum Excel General
    Replies: 8
    Last Post: 08-29-2016, 11:03 AM
  2. [SOLVED] Index/Match/Sumifs?
    By overbomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-12-2016, 06:07 AM
  3. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  4. [SOLVED] Sumifs/match/index?
    By mstoto in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-14-2014, 09:23 AM
  5. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  6. [SOLVED] Sumifs or lookup or index/match based on columns and rows
    By ned0 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2013, 08:48 PM
  7. SUMIFS, INDEX, and MATCH-- how to fix?
    By sofib09 in forum Excel General
    Replies: 6
    Last Post: 12-13-2010, 11: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