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...
Bookmarks