Google Sheets Split function with Array
I have a table of current work hours in column A. Column B has newly assigned work hours. Column C just sums up the first two columns to show the new work hours. Column B changes based on some other factors in the sheet. I have this mostly working, but the issue I have come across is that sometimes a person will have x+x current hours listed. I am trying to split the numbers in that cell and then sum them together to get the max new hours. The end result should look like this:
| Col A | Col B | Col C |
|---|---|---|
| 40 | 3 | 43 |
| 35 | 5 | 40 |
| 25+3 | 2 | 30 |
I was able to accomplish this using this formula:=IFS(A1="","", ISNUMBER(A1)=TRUE,ADD(A1,B1),ISNUMBER(A1)=FALSE,ADD(SUM(SPLIT(A1,"+")),B1)). However, doing this means I have to drag the formula down all the cells I want to calculate. It works fine that way, but I was hoping to just use an array instead. Is there any way to convert this into an array?
I've tried using this: =ARRAYFORMULA(IF(ISBLANK(A1:A15),"", IF(ISNUMBER(A1:A15)=TRUE,ADD(A1:A15,B1:B15),ADD(SUM(SPLIT(A1:A15,"+")),B1:B15)))) but once it gets to a column containing the + symbol, it spits out an error.
try:
=INDEX(QUERY(QUERY(SPLIT(A1:A3, "+")*1, "select Col1+Col2"), "offset 1", )+B1:B3)
- Perl calculate average from randomly populated array
- Are there any performance advantages to use `Application.Match` on a VBA array instead of looping over it to check if an element is present or not?
- Combine two streams to display as one in GUI
- How to convert uint8 Array to base64 Encoded String?
- Json Object Parsing using shell script
- How to initialize array to tuple type in TypeScript?
- Is there a way in C++ to get a sub array from an array?
- How can I use in_array if the needle is an array?
- How to sort my array by length of its keys array in javascript?
- How to save a value to a file after a person has entered the value in terminal in C?
- C++ the dynamic array and file reading don't work together
- How to change the name of an array using a function to access a totally different array in Arduino / C/ C++
- How to get a slice as an array in Rust?
- How to merge two array of object into one array of object based on key?
- How to destructure this Array
- How to check if two indexed arrays have same values even if the order is not same?
- Reverse an array in JavaScript without mutating the original array
- PHP create array group by key and value
- Is there an algorithm for shuffling objects in an array randomly WITHOUT utilizing Lists and Collections
- accessing array and objects
- 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