Sum each row in a spilled range

[darkwing1711]

Hello all!

I am trying to sum each row in a spilled range. I imagine I would have to use the MMULT function, but I can't figure it out.


I kinda know how to sum each column so I've just tried to modify it to sum the rows instead but now luck.

=MMULT($I$9#,SEQUENCE(COLUMNS($I$9),,,0))

Thanks in advance!

 

[Fluff]

How about

=BYROW(I9#,LAMBDA(br,SUM(br)))

 

[awoohaw]

The Mr. Excel forum has a tool which allows you to post mini workbooks (including formulas and the value) of your work. It is called xl2bb add in (link below).
If you cannot use that, then please post your data as a table. It need not be all of your data but enough to give various calculation scenarios.

Thanks in advance.

 

[darkwing1711]

How about

=BYROW(I9#,LAMBDA(br,SUM(br)))

This worked wonderfully! Thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback.