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...
Try this:
=BYROW(C3:F6*H3:K6/B3#,LAMBDA(r,SUM(r)))
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Can I ask why the BYROW / LAMBDA combination is preferred over the much easier to read SUMPRODUCT function?
BYROW and LAMBDA allow the formula to spill down, which is what the OP wants. If you have further questions on this, you must open your own thread, please.
What is 'easy to read' is just a matter of experience and familiarity.
By the way, C3:F6*H3:K6 is a shorthand version of a SUMPRODUCT, anyway.
Last edited by AliGW; 10-09-2023 at 10:01 AM.
@paulma1960
Thanks for the rep, but please mark the thread as SOLVED.
Ah great, thanks Ali. And simple, I didn't realise you could put more than one array in the first argument of BYROW. Obviously, BYROW treats C3:F6*H3:K6/B3# as one array.
Correct.
Please mark the thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks