Test

[Molly Brennholz]

Test

Test formula post


https://www.excelforum.com/excel-for...plication.html

[FORMULA] =_xlfn.SINGLE(MMULT(TRANSPOSE(N(IF({1};$B$37:$B$45 )));(($K57>=$C$37:$C$45)*(L$54=$A$37:$A$45))))*$D39
[/FORMULA]

_____ Workbook: Customer Forecast.xlsx ( Using Excel 2007 32 bit )

Row\Col	L
57	=_xlfn.SINGLE(MMULT(TRANSPOSE(N(IF({1},$B$37:$B$45))),(($K57>=$C$37:$C$45)*(L$54=$A$37:$A$45))))*$D39

Worksheet: Forum

_____ Workbook: Customer Forecast.xlsx ( Using Excel 2007 32 bit )

Row\Col	L
57	=_xlfn.SINGLE(MMULT(TRANSPOSE(N(IF({1},R37C2:R45C2))),((RC11>=R37C3:R45C3)*(R54C=R37C1:R45C1))))*R[-18]C4

Worksheet: Forum