Forum Discussion

Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 17, 2021
Solved

Excel 365 SUM dynamic array at row level

Hi (no LAMDBA here). I've been struggling with this for a moment, searched here & there for something similar to no avail. In the below pic. Dummy arr is the representation of an array that doesn't...
excel
Formulas and Functions
office 365
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jun 17, 2021

    Lorenzo 

    That's a classic MMULT() solution.

     

    =MMULT(A2:C4,SEQUENCE(COLUMNS(A2:C4))^0)

     

Lorenzo's avatar
Lorenzo
Silver Contributor
Jun 16, 2022

Hi PeterBartholomew1 

I appreciate your follow up on this issue. Since I have the 1st wave of LAMBDAs I figured that one out but this can help others so thanks for sharing it

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 16, 2022
I wasn't trying to patronise! I saw the old discussion on your profile page and though that bringing it up to date might help someone in future if they search the topic.

Resources