Forum Discussion
Lorenzo
Jun 17, 2021Silver Contributor
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...
- Jun 17, 2021
PeterBartholomew1
Jun 16, 2022Silver Contributor
Since you now have Lambda functions, the solution simplifies. First, assuming the dummy array has been given a name
= BYROW(Dummy_arr, Sumλ)
where
Sumλ = LAMBDA(x,SUM(x))
or including the array definition within a LET
= LET(
dummyArr, {1;10;100}*SEQUENCE(1,3),
BYROW(dummyArr, Sumλ)
)
I have attached a file, but it contains little by way of additional information.
- LorenzoJun 16, 2022Silver Contributor
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
- PeterBartholomew1Jun 16, 2022Silver ContributorI 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.