A1=x, B1=$10, C1=5%

A2=x, B2=$20, C2=3%

A3="subtotal x", B3=$30, C3=3.7%

A4=y, B4=$40, C4=8%

A5=y, B5=$20, C5=7%

A6=y, B6=$50, C6=15%

A7="subtotal y", B7=$110, C7=11%

A8=z, B8=$100, C8=7%

A9=z, B9=$20, C9=10%

A10="subtotal z", B10=$120, C10=7.5%

The formula should return: $1.11 (which is 30*3.7% which is the smallest of the 3 operating profits of the subtotals)

I am using: {=SMALL((MMULT(GAM!$S$9:$S$34,GAM!$T$9:$T$34))*(GAM!$C$9:$C$34="Sub-Total"),1)} but I keep getting a #value! message.

Your help is greatly appreciated!