Skip to content

Instantly share code, notes, and snippets.

@ncalm

ncalm/excel-lambda-SUMPRODUCT2.txt

Created April 30, 2024 17:14
Show Gist options
  • Save ncalm/f6ce93ed9825ce6a330cb0ae3d34eec1 to your computer and use it in GitHub Desktop.
Save ncalm/f6ce93ed9825ce6a330cb0ae3d34eec1 to your computer and use it in GitHub Desktop.
Download ZIP
This Excel LAMBDA functions mimics SUMPRODUCT but allows a single 2D array as its only argument
Raw
excel-lambda-SUMPRODUCT2.txt
IFOMITTED = LAMBDA(arg,then,IF(ISOMITTED(arg),then,arg));
SUMPRODUCT2 = LAMBDA(array, [axis],
SUM(IF(IFOMITTED(axis,0)=0, BYROW, BYCOL)(array, PRODUCT))
);
@ncalm
Copy link
Author

ncalm commented Apr 30, 2024

Explanation:
https://www.flexyourdata.com/excel/free-lambda-sumproduct-for-2d-arrays/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment