Citat:
Ursprungligen postat av Lancelot
Det var en enkel x * y som inte fungerade, där allt var på samma blad...
|
Märkligt, bör inte vara några problem.
https://support.google.com/docs/bin/...&page=table.cs
Array SUMPRODUCT SUMPRODUCT(array 1, array 2, ...array 30)
Multiplies corresponding elements in the given arrays, and returns the sum of those products. Array 1, array 2,...array 30 are arrays whose corresponding elements are to be multiplied. At least one array must be part of the argument list. If only one array is given, all array elements are summed.