Results 1 to 7 of 7

SUMPRODUCT with BYROW? MAP? INDEX?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-31-2021
    Location
    Kassel, Germany
    MS-Off Ver
    365 v2409
    Posts
    207

    SUMPRODUCT with BYROW? MAP? INDEX?

    Hi all,

    I'm attempting to create a dynamic array to replace single-cell formulas that use SUMPRODUCT. In the attached file, col. M shows the single-cell formulas with expected values that I'd like replicated in col. N with a dynamic array formula. You can see my attempts to use BYROW and MAP are failing and looking for a working solution. All suggestions are appreciate and TIA...
    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] Dyn.Arr. fx for sub-totals: ByRow?
    By paulma1960 in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-27-2023, 06:06 AM
  2. [SOLVED] Is it possible to use TREND formula BYROW on a #Spill Range?
    By chris01395 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-07-2023, 06:10 AM
  3. [SOLVED] help with a BYROW
    By guillaume0314 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-30-2023, 11:40 AM
  4. [SOLVED] BYROW retrieve value in a dynamic array
    By guillaume0314 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-21-2023, 12:47 PM
  5. Combine two working formulae using BYROW (or other function(s))
    By TMS in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-19-2023, 12:11 PM
  6. [SOLVED] BYROW(...LAMBDA(...) ) result in #CALC! error
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-18-2022, 07:17 AM
  7. Replies: 5
    Last Post: 04-20-2012, 08:54 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