https://bugs.documentfoundation.org/show_bug.cgi?id=155755
--- Comment #2 from Eike Rathke <[email protected]> --- That wouldn't deliver a single return value though like SUMIF() (note it's not SUM.IF() that was probably because in French it's SOMME.SI()) but an array/matrix and that can already be accomplished by entering =range1*range2*condition as array formula, i.e. closing it with Shift+Ctrl+Enter instead of Enter. Example: =A1:A5*B1:B5*(C1:C5<>23) multiplies cells of A1:B5 with cells of B1:B5 if the corresponding value in C1:C5 does not equal 23; returns an array of 5 values, 0 if condition is not met. If in comment 0 you meant to multiply all values of a range for a condition, that can be accomplished similar using =PRODUCT(IF(C1:C5<>23;A1:A5;"")) as array formula (French PRODUIT()). -- You are receiving this mail because: You are the assignee for the bug.
