Results 1 to 6 of 6

SUMPRODUCT Dynamic Help

Threaded View

  1. #1
    Registered User
    Join Date
    06-23-2015
    Location
    Brussels, Belgium
    MS-Off Ver
    Excel 2010
    Posts
    60

    SUMPRODUCT Dynamic Help

    Dears,

    I need your help to finish my Sumproduct Formula and get it dynamic and not dependent of the number of rows or columns in the Sheet containing the Data source,

    the formula is contained in the Sheet Overview 2017, in the table E43:S60,
    This formula is searching for the sales or FCST based on several criterias (Brand, Format, botlle type, Month number and year,Sales or FCST)
    If Sales, this is returning the formula to sheet SPT, if FCST, to the sheet SPT FCST,

    For the first part of formula, to retrieve the sales, i have no issues and it is dynamic, but for the Second part, if I need FCST info, i need the formula to be equal to the number of row or columns contained in the sheet SPT FCST, which drastically reduce the dynamic use of my file,

    Could you please help me in correcting it ? I am running out of ideas,

    In attached the concerned file,

    thanks in advance !

    Stef
    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] Sumproduct with a dynamic range...is that the only way?
    By som3on3_10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-30-2014, 02:35 AM
  2. [SOLVED] SUMPRODUCT Formula with Dynamic Last Row
    By freybe06 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-19-2013, 10:43 AM
  3. Dynamic Sumproduct Lookup
    By matt4003 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-30-2010, 03:14 AM
  4. Sumproduct for dynamic range
    By Bob@Sun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2010, 06:32 AM
  5. Sumproduct with dynamic array
    By benaw in forum Excel General
    Replies: 3
    Last Post: 10-18-2009, 07:24 PM
  6. Need help with sumproduct & dynamic ranges
    By bill_s1416 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2006, 11:40 PM
  7. [SOLVED] Need help with sumproduct and dynamic ranges
    By Bill_S in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-18-2006, 09:25 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