Hi,
Using the Aspose.Cells version 24.10.0 on this test Excel workbook:
TestCase13.zip (11.7 KB)
I have a formula in Output!E11 that looks like this:
=LET(W,Input!$W$4:$W$14,X,Input!$X$4:$X$14,F,Input!$F$4:$F$14,AA,I…...value for a formula using LET MAP and LAMBDA Aspose.Cells Product...$F$4:$F$14,AA,Input!$AA$4:$AA$14,SUM(MAP(W,X,F,AA,LAMBDA(iW,iX,iF,iAA...