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
Bookmarks