arraysgoogle-sheetsmultidimensional-arraytransposegoogle-query-language
Multiply each row using Arrayformula
In Google Sheets, I have the following data:
| A | B | C | ... | G | TOTALS
1 | 100| 200| 400| ... | 870| =PRODUCT(A1:G1) |
2 | 120| 240| 360| ... | 232| =PRODUCT(A2:G2) |
3 | 125| 425| 100| ... | 509| =PRODUCT(A3:G3) |
How can I create the TOTALS column using ARRAYFORMULA?
Solution
shorter and should be faster (with some tweaking for sure):
=INDEX(IFERROR(1/(1/DPRODUCT(TRANSPOSE({A1:A*0, A1:G}),
SEQUENCE(ROWS(A1:A)), {IF(,,); IF(,,)}))))
- Group 2d array data by one column and create a subarray from another column per group
- Restructuring Multi Dimensional Array Format
- How to reformat a nested array?
- restructure a multidimentional array in php based on its values
- Change the structure of a multi-dimensional array
- Remove first column from each row of a 2d array and apply values as first level keys
- How to re-arranging an array
- Rearranging multidimensional array
- reorder multidimensional php array trouble
- How to sort multidimensional array by value?
- Sort single-element rows of a 2d array in a descending direction
- Parse query string into an associative array
- Deleting rows in callback function in array_walk()
- Convert a string with two sets of delimiters into a flat associative array
- Convert a flat associative array into a flat indexed array alternating the original keys then original values
- How to check non-constant array
- Sort all rows of a 2d array according to one row and maintain columnar relationships
- Sort rows of a 2d array by a column
- Sort a 2d array (which is nested inside of a multidimensional array) by a column
- Sort children within each parent subarray of a multidimensional array by a column
- Sort a multidimensional array by a column then by first level keys
- Sorting array in PHP based on another array indexes
- Sort a 2d array by a column DESC
- Sort an associative array the same way that another flat array is sorted
- Sort a 2d array by a column without preserving the first level keys
- Split a flat array into subarrays based on a delimiting element
- Group recurring values from a flat array into their own respective subarrays
- Split a flat array into 3-element subarrays
- Split a flat array into a predefined number of arrays
- How to check if an array is empty or exists?