arraysgoogle-sheetslambdasumgoogle-sheets-formula
Sumif (google sheets) but data is every nth cell in a column, every nth column based on cell n-4
Im trying to make a budget tracker
Is there a way i can sum every nth cell in a column if the n-4 is a specific string?
I found this but not sure how i can add a "=person A" to the criteria.
Is there a better way to format this data ?
Solution
try in C2 and drag to the right:
=INDEX(BYROW(REGEXREPLACE($A2:$A3, "(?i)total ", ),
LAMBDA(T, SUM(IFNA(FILTER(C7:C15, C4:C12=T))))))
⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀ ⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀⠀
- How to recursively merge two multidimensional arrays
- Why isn't array_merge() merging arrays by reference?
- Ignoring posts in wordpress already used in a loop
- Merge two flat arrays with the same count to form an array of associative arrays
- Array value sum by key value php
- Sum the values of a column in a 2d array
- Group values in an array of single-element arrays by second level key and sum values within each group
- Store and read hash and array in files in Perl
- Merge a flat associative array into another associative array
- Array of data showing in console but not in HTML after passing it through dialog in Angular project
- Sizeof vs array size
- How to merge two associative multidimensional arrays
- Merge two multidimensional arrays related by shared subarray column values
- Replace an array's values with the values from a lookup array
- Print grouped data as a single array
- Merge and sum data from two associative multidimensional arrays
- Sorting an array before inserting to database
- Array Intersection - only once
- Sort values within each row of a 2d array
- Group 2d array data by one column and then sort by another column
- Append data from one subarray to another subarray
- Sort an array according to another array
- Move an element by key before another element by key in the context of an associative array
- How do I desctructively iterate over an array of strings in rust?
- How to generate a random number array and sorting this array using php?
- Ajax Parse Error when returning array from PHP
- PHP MYSQL Array and sort
- Sort a 2D array by multiple columns
- Short circuit Array.forEach like calling break
- Passing a NumPy 3d array to a C function with a triple pointer as an argument