numbers sumproduct function
Good morning, i wanna implement this excel function in numbers: = SUMPRODUCT(–(Conditional Array = “Condition”),Array1, Array2)/SUMIF(Conditional Array,”Condition”,Array2). how can i do that??
thanks
Luigi
Question marked as
The first part appears to be doing a "sumproductif". The first "range" of "-(conditional array = condition)" is not allowed in Numbers. I think the simplest thing to do is to insert a new column that, row by row, multiplies "array 1" and "array 2". If we refer to it as "array 3", the formula would be SUMIF(Conditional Array,”Condition”,Array3)/SUMIF(Conditional Array,”Condition”,Array2)