Results 1 to 10 of 10

Decoding an excel formula on sumproduct

Threaded View

  1. #1
    Registered User
    Join Date
    12-16-2021
    Location
    Madison
    MS-Off Ver
    365
    Posts
    6

    Lightbulb Decoding an excel formula on sumproduct

    Hello Everybody,

    This is my first post in this forum and I need help with an excel formula in a worksheet. It is a 'sumproduct' but I am not able to decode which rows and columns are linked in the formula because of the 'indirect function' used. The formula is:

    Sumproduct(Inventory!C$3:InventoryC7,INDIRECT(ADDRESS(FC!$A$2006)-Inventory!$A7+1,Column(FCB$4),,,"FC")):FC!B$2006)

    Here sumproduct in a sheet is calculated using data from two sheets 'inventory' and 'FC'.

    I would be really grateful if someone can help me in understanding which rows of 'FC' sheet are multiplied with the rows C3:C7 in the 'Inventory' sheet.

    Kind regards,
    Poonam
    Last edited by PoonamKhatri; 12-16-2021 at 01:56 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Vlookup formula Decoding help needed...
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2014, 03:56 PM
  2. decoding formula assistance
    By eehimes in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-31-2014, 01:44 PM
  3. Replies: 2
    Last Post: 06-20-2014, 12:42 PM
  4. Decoding an excel formula
    By nadeemsmarty in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 01:15 PM
  5. Encoding-Decoding
    By laxmanann in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-09-2014, 02:33 AM
  6. Base64 decoding using excel function
    By deepak1986 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2012, 02:21 PM
  7. decoding formula issue
    By Ricersux in forum Excel General
    Replies: 1
    Last Post: 02-18-2008, 12:02 PM

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