Forum Discussion
Danijel Radic
Mar 28, 2018Copper Contributor
Multiplying with few conditions
Hi.
I need a help with some calculations where few conditions have to be met.
First is that values in column B have to meet values in column D. Then if so, the value in column B multiplies with t...
Detlef_Lewin
Mar 28, 2018Silver Contributor
Danijel,
my guess:
=MAX(SUMPRODUCT(($E$11>=F$10:H$10)*(B3*F3:H3)*(B3>=D3)),B3*E3)