IFOMITTED = LAMBDA(arg,then,IF(ISOMITTED(arg),then,arg));
SUMPRODUCT2 = LAMBDA(array, [axis], 
    SUM(IF(IFOMITTED(axis,0)=0, BYROW, BYCOL)(array, PRODUCT))

I wanted to be able to pass a 2D array as a single argument to SUMPRODUCT. But it doesn’t work like that, so I worked around it and created SUMPRODUCT2.

This document shows my thought process and steps I went through to get to the final result.

I hope you find it interesting.

Here’s a link to the original post of this content on LinkedIn.


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>