SUMPRODUCT that multiplies

Hello, I was looking to do a kind of sumproduct function that multiplies the resulting values. Using the sumproduct i can identify specific rows that i want via the double negative criteria. However rather than adding up the product of the arrays, i'd like to multiply them. I couldn't get it to work with the PRODUCT formula and IF-AND criteria. In the attached image with criteria needing 3 Yes's, sumproduct would give me a value of 2, but I'd like to get a value of .25 (1*.5*.5). Help is much appreciated.Excel.png

Presumably you want the product of values in E5:E9 for which the corresponding values in B5:D9 are all Yes by row. You'd need to use an array formula for that.

Formula:

Please Login or Register  to view this content.

To enter an array formula, hold down [Ctrl] and [Shift] keys before pressing [Enter]. You could avoid array formula entry by using the less efficient

Formula:

Please Login or Register  to view this content.

Tangent: Windows 7 is NOT your MS Office version.

I wasn't able to make the array method work, but the other one did, thank you! Also, thanks for the correction, I'll be sure to update.